Forum Discussion
Explanation of a formual
HI All, I am just learning formulas in excel. I inherited a work sheet that had this formula used. =A5/(1-(A13+B14)) in this case I know that A5 is $10. (round to zero decimal) A13 is 4...
Step by step:
1. =A5/(1-(A13+B14))
2. =10/(1-(40%+0%))
3. =10/(1-(0.4+0))
4. =10/(1-0.4)
5. =10/(0.6)
6. =10/0.6
7. 16.6666666667
1. =A5/(1-(A13+B14))
2. =10/(1-(40%+0%))
3. =10/(1-(0.4+0))
4. =10/(1-0.4)
5. =10/(0.6)
6. =10/0.6
7. 16.6666666667
