# Weird Percentage Question

#### c.clavin

##### Board Regular
Hi all. I'm trying to find a number that is exactly 4% of an original number. When I use the formula "=1473*0.96" I get 1414.08 then when I go to find the percentage change between 1414.08 and 1473 I get 4.17% What gives?

The number I should be getting is a number like 1416.34 Is there another formula I could use to get a more accurate number? It seems like a weird issue. Thanks.

### Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use \$ signs: \$V\$2:\$Z\$99 will always point to V2:Z99, even after copying

#### offthelip

##### Well-known Member
That is correct, this is because you reduced the value by 4% by multiplying by 0.96. But now to get back to 100% you have to increase by 100/96 = 1.041667, i.e slightly more than 4%
It is more obvious if say reduce 100 by 20% or 1/5 which gets to 80, now to increase back to 100 you need 20 which is 1/4 of 80 not 1/5.

#### c.clavin

##### Board Regular
Interesting. As you can tell I'm not really a math guy haha. Is there a way to get the exact value of 4% of a number this way?

#### offthelip

##### Well-known Member
Depends waht you mean by 4% of a number, you appeared to be calculating the 4% reduction in a number by multiplying by 0.96, what you did was correct if you were trying to reduce the number by 4%
If you actually want 4% of a number just multiply it by 0.04 that is exactly 4% of the number. Just don't think that by then increasing it by 4% you will get back to the original number because you won't

Replies
8
Views
119
Replies
3
Views
94
Replies
1
Views
170
Replies
6
Views
354
Replies
7
Views
179

1,195,835
Messages
6,011,880
Members
441,651
Latest member
drewe2000

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

### Which adblocker are you using?

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

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