Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Need Formula or Function to calculate Margin (reverse of Percent a
I need function to calculate the reverse of adding percent margin to a number
(e.g. product price). For example, I have a number 100, and I want to identify the number that will result in 100 after 40% deduction (discount). I am looking for a formula or function in excel that will result in 166.67. Note that 166.67 - (166.67 * 40%) will result in my original number of 100. Some business calculator has this function (label as MU for Citizen calculator). Anyone knows how does Excel handles this, or know of a formula that can handle this. Another example is: The formula that will return 250 after input of 100 and 60% discount. That is 250 - (250 * 60%). Note that in my 2 example, the inputs are 100 and 40% with result of 166.67, and 100 and 60% with result of 250. Thanks a lot.. |
#2
|
|||
|
|||
"Ken" wrote...
.... I am looking for a formula or function in excel that will result in 166.67. Note that 166.67 - (166.67 * 40%) will result in my original number of 100. .... Just a little algebra is all that's needed. 166.67 - (166.67 * 40%) = 166.67 * (1 - 0.40) = 100 so 100 / (1 - 0.40) = 166.67 So if you enter 100 as P and 40% as d, the formula to get 166.67 is P/(1-d). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function Formula is displayed not results | Excel Worksheet Functions | |||
how to enter a formula using column() function for a range | Excel Worksheet Functions | |||
calculate percent increase | Excel Discussion (Misc queries) | |||
calculate percent from multiple criteria | Excel Worksheet Functions | |||
What function or formula do I use to calculate ROI with this data? | Excel Worksheet Functions |