![]() |
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. |
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. |
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