Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |