Need to reverse a mathematical excel formula to do reverse calculation of what it currently does. I need to do a reverse mathematical calculation in a formula in excel. To start, I created a formula to calculate for me ebay and paypal fees for items that I list.
The criteria are as follows:Up to $50, 8%. Up to $1,000 then first $50 are 8%, the rest is 4.5%. Over $1,000 and charges are 8% for first $50, 4.5% for next $950, and 1% for the rest.
After all that, 5% discount. Then add paypal fees of 1.9% and $0.30. So this formula I was able to do as follows:=IF(A2 Math.
Similar questions: reverse mathematical excel formula calculation.
Could be difficult, except.... This could get really difficult, as not every math function has an inverse. And this is not really a math function. But Exel has a "goal Seek" feature that can save the day.
You just give it your existing formula and tell it what value you want in which cell and and it juggles the input values to reach your goal. See: mistupid.com/viewlets/excel/xlgoalseek.htm .
" "Need to reverse an excel formula to do the reverse matchematical equation." "How are those math formula images created on wikipedia. Org? " "Is there a formula or macro I can use in Excel 2003 to auto hide rows not in use?" "Is there any reason why I shouldn't use Excel's built-in ANOVA (statistical calculation) feature?
" "In excel, what is the fuction that is used type of function formula" "Is there software that will take a math equation and convert it into an Excel spreadsheet equation or the reverse? " "Excel - need help with formula in worksheet" "Excel - when I add a formula, hidden columns are revealed. How do I fix that?
Need to reverse an excel formula to do the reverse matchematical equation.
How are those math formula images created on wikipedia. Org?
In excel, what is the fuction that is used type of function formula.
Excel - need help with formula in worksheet.
Excel - when I add a formula, hidden columns are revealed. How do I fix that?
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.