| Home |
| Search |
| Today's Posts |
|
#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). |
| 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 | |||
Threaded Mode
