formula to subtract percentage from whole

S

Shevvie

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.

Appreciate your help
 
E

Eduardo

Hi,
in the cell where you want the result enter
to increase

=A1*1.15

to decrease

=A1/1.15
 
J

Joe User

Shevvie said:
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%)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top