View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
pdberger pdberger is offline
external usenet poster
 
Posts: 258
Default 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.