Need to reverse an excel formula to do the reverse matchematical equation?

Need to reverse an excel formula to do the reverse matchematical equation. So this excel formula does ebay and paypal fees calculations. Here is the breakdown: Up to $50 is 8%.

Up to $1,000, first $50 is 8%, the rest is 4.5%. Over $1,000, first $50 is 8%, next $950 is 4.5%, the rest is 1%. Then after all that there is a 5% discount.

Then add paypal fees which are 1.9% + $0.30. So I was capable of creating the excel formula which looks like this:=IF(A2 Math.

Similar questions: reverse excel formula matchematical equation.

The problem is your boundaries... I'd recommend reading through this so you understand why I did the calcs the way I did (and why I re-wrote yours), but if you're just eager to see the solution, scroll to the "real deal" section at the bottom! I don't know ebay and Paypal fees well, but your equation doesn't really look right to me - here's the problem that I see: Taking the 50, so your calculation says to: (((((A2-50)*0.045)+4)*0.95)+A2*0.019+0.3) ^^ What is this +4? (55.1222-50)*.045)+4)*.095 + 55.1222*0.019+0.3 which equals: $5.36629585 in fees , or 49.76 net.

Sure, it's only $.25 off from the $50 ACTUAL asking price, but you're at the bottom end of the scale from 50-1000 using the 4.5% - as the net gets closer to 1000, the formula gets further and further off! Here's the real deal: Set up a table in excel that looks like this (ignore the colored boxes): Make sure the Cells are lined up in the correct colums/rows, otherwise the formula won't work. Now, a few rows down, create another section so your sheet looks like this (ignore the .30 and (0.27)).

: The first formula will calculate a total cost based on the net you want to receive. Copy and paste this fomula into Cell D8: =IF(B8Give it a shot - I think that's what you're looking for. (Notice the net to total and total to net are always inversely equal to each other - whcih is how it should be!

) There may be some rounding issues where you miss a penny, but not much I can do about that. Hope that helps! Sources: Too many years of Report Development.

" "In excel, what is the fuction that is used type of function formula" "Need to reverse a mathematical excel formula to do reverse calculation of what it currently does. " "How are those math formula images created on wikipedia.Org?

What does a comma in a math equation mean (such as i/h=a, h>a).

Excel - need help with formula in worksheet.

I need a function or equation for use in Excel to calculate hours worked....

In excel, what is the fuction that is used type of function formula.

Need to reverse a mathematical excel formula to do reverse calculation of what it currently does.

How are those math formula images created on wikipedia. Org?

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.