| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Taking away a percentage from a sum.
Maybe:-
=((3600/H16)/100)*85 Mike "the-jackal" wrote: Hi, I would like to subtract 15% from a cell which already has a formula. for example: =SUM(3600/H16) This gives me an answer, but I now want to take 15% off that answer without using any other cells. I thought =SUM(3600/H16)-1.15 would work but of course it just takes away 1.15 from the sum not 15% H16 will be an amount gathered from another worksheet and will be different each time. Any help would be appreciated Carl -- the-jackal |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Taking out Emptys | Excel Worksheet Functions | |||
| Taking off or hiding #N/A | Excel Discussion (Misc queries) | |||
| taking percentages | Excel Discussion (Misc queries) | |||
| Calculating a percentage with the end percentage in mind | Excel Discussion (Misc queries) | |||
| Taking Attendance | Excel Discussion (Misc queries) | |||
Threaded Mode
