Percentage query/formula help

[rochytall2000]

I need help with the below formula

=H3-(H3*$F$3)

I'm trying to return the revised figure once a percentage has been taken off but my formula is not working correctly (as expected I should say)

H3 is the initial value
F3 contains the percentage value (0.01)

but for some reason it is taking too much off when I copy to the next cell and so on

For example

9707-(97) = 9610

9610-(96) = 9514 but Excel is returning 9418 subtracting 192

In effect doubling the value of the percentage to be subtracted

If I do it where i Just have the percentage amount returned it works but I want to return the new value of H3 in I3 not the percentage value.

Help please

Thanks
Duncan

 

[Chris Mack]

What does the workbook structure look like?

 

[rochytall2000]

Here an example:

• Jan Feb March
• 11599 11367 11139 decrease by 2%
• 13213 12949 12690 decrease by 2.25%
• 6759 6624 6491 decrease by 2.25%
• 9609 9417 9229 decrease by 1%

The example above shows the results of my existing calculation starting with January obviously. I want to track it out for many months playing with percentages but obviously I can't when the results my formula is giving me are wrong (my fault I'm sure).

Thanks for taking the time to lok
Duncan

 

[Chris Mack]

Hmmm, I can't think why it wouldn't be working.

What cells are we looking at, and where do the formulas go?

 

[rochytall2000]

Hmmm, I can't think why it wouldn't be working.

What cells are we looking at, and where do the formulas go?

I'm sorry I don't understand what you need me to do (I'm having a bad day!)

 

[Chris Mack]

Hey, no problem.

Basically I'm trying to figure out why your formula is doubling the percentage to subtract, but I can't really picture what it looks like and therefore what you're trying to achieve. So if you could give a description, like, this data is in A1, then I have a formula in A2, then A3, to subtract 1%, and they're all referencing a percentage figure in $F$3, etc.

Alternatively, some people upload their spreadsheets to online storage which can be really helpful.

Chris.

 

[rochytall2000]

Ah OK, sorry for being a bit slow

Hopefully you can see an extract of the file here https://drive.google.com/file/d/0B5GpQWj2a2amWkFDZURHVHBLMGM/edit?usp=sharing

Thanks again for looking

Duncan

 

[Chris Mack]

You need to remove the second "$" so the formula can reference different rows. At the moment they're all looking at $C$3 (2%).

Chris.

 

[rochytall2000]

Such an easy fix. I couldn't see it for looking!!

Duncan

 

[Chris Mack]