Calculating with Percent Increase

**Jfxnc** · 11-28-2010, 03:53 AM

Ok so A1=1.3564
B1=26.2677
If on a calculator 26.2677+1.3564%= 26.6239950

Whats the formula?
Also I have 100+ of these to do that all are + different %s

Have been stuck on this, very frustrating thanks for any help!!

**Maistrye** · 11-28-2010, 04:01 AM

Hi,

For the calculator, when you go and put in a number like 20 and then hit +5%, what it is actually doing is multiplying the the first number by 105%. In other words, the result is 100% of 20 plus an additional 5% of 20 -- or restating the above, 105% of 20.

So, for your formula to work, you would want to put in the following:
=B1*(100%+A1%)

This same formula could be used wherever you want to do this (just change the cells the formula references). This formula can also handle negative %'s. That is, if you hit -5% on your calculator instead of +5%.

S