ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Percentage formula help (https://www.excelbanter.com/excel-worksheet-functions/119092-percentage-formula-help.html)

LB

Percentage formula help
 
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.



pdberger

Percentage formula help
 
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

"LB" wrote:

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.




PCLIVE

Percentage formula help
 
I believe this:

=A1 + (A1*.075)
=A2 - (A2*.075)

HTH,
Paul

"LB" wrote in message
...
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.





All times are GMT +1. The time now is 07:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com