| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula to subtract percentage from whole
I want to be able to create a forumla to increase or decrease the percentage
of a whole number i.e. Nett: 81.47 increase by 15% to give me the total and vice versa 92.27 decrease by 15% (I can do this on the calculator). Formula NOT reliant on other cells. Appreciate your help |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula to subtract percentage from whole
Hi,
in the cell where you want the result enter to increase =A1*1.15 to decrease =A1/1.15 "Shevvie" wrote: I want to be able to create a forumla to increase or decrease the percentage of a whole number i.e. Nett: 81.47 increase by 15% to give me the total and vice versa 92.27 decrease by 15% (I can do this on the calculator). Formula NOT reliant on other cells. Appreciate your help |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula to subtract percentage from whole
"Shevvie" wrote:
I want to be able to create a forumla to increase or decrease the percentage of a whole number i.e. Nett: 81.47 increase by 15% to give me the total and vice versa 92.27 decrease by 15% (I can do this on the calculator). Formula NOT reliant on other cells. =81.47*(1+15%) =92.27*(1-15%) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtract a known percentage | Excel Discussion (Misc queries) | |||
| add & subtract time in 1 formula | Excel Worksheet Functions | |||
| Subtract 30 minutes from Formula | Excel Worksheet Functions | |||
| subtract formula | Excel Discussion (Misc queries) | |||
| divide a total, subtract one then format as a percentage | Excel Worksheet Functions | |||
Linear Mode
