Percentage formula help

  • Thread starter Thread starter LB
  • Start date Start date
L

LB

I have 2 figures, 1 I want to add 7.5% to it and get the total, the 2nd
figure I want to subtract 7.5% and get the total. Have totally forgotten
how to do percentages.

Any help greatly appreciated, thanks.
 
LB

A B
1 X
2 =1.075*A1
3 =0.925*A1

Or, if you wanted to apply a variable percentage in cell B1:

2 =(1+B1)*A1
3 =(1-B1)*A1

HTH
 

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

Back
Top