formula to subtract percentage from whole
"Shevvie" wrote:
I want to be able to create a forumla to increase
or decrease the percentage of a whole number i.e.
Nett: 81.47 increase by 15% to give me the total
and vice versa 92.27 decrease by 15% (I can do
this on the calculator). Formula NOT reliant on other
cells.
=81.47*(1+15%)
=92.27*(1-15%)
|