| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Percentage formula in Excel spreadsheet | New Users to Excel | |||
| Formula for Annualized percentage | Excel Worksheet Functions | |||
| How do I create a formula by percentage within a formula? | Excel Worksheet Functions | |||
| formula percentage problem | New Users to Excel | |||
| Percentage Formula | Excel Worksheet Functions | |||
Linear Mode
