# Percentage query/formula help

#### rochytall2000

##### New Member
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.

Thanks
Duncan

### Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
What does the workbook structure look like?

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

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

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

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!)

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.

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.

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

Duncan

Replies
4
Views
284
Replies
8
Views
627
Replies
7
Views
488
Replies
15
Views
528
Replies
11
Views
991

1,221,127
Messages
6,158,104
Members
451,465
Latest member
Big_Bill62

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back