View Single Post
  #1   Report Post  
the-jackal the-jackal is offline
Junior Member
 
Location: South Woodham Ferrers, Essex
Posts: 19
Default Taking away a percentage from a sum.

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