# Excel Percentages

#### Jean Stewart

##### New Member
Hello I have to update a price list by adding columns to show the price increase by % from 1 - 5%. I have added the percentage and done the =%+Current price. This is ok on 0.37 data but once the value increases to say 2.14 or 1260.00 it gives me an incorrect figure for example my sheet is currently telling me the 2.14 plus 5% is £2.19 where as it should be more like £2.25. Anyone any ideas what I'm doing wrong?

#### Jean Stewart

##### New Member
Thank you Hero see file - bet I'm being stupid!!

#### Attachments

• 9.8 KB Views: 2

#### herofox

##### Active Member
hi Jean ......
You can Use This Formula
Code:
``=\$A2+(\$A2*B\$1)``
I think this is the simplest equation that can be used

#### Attachments

• 11.7 KB Views: 3
Last edited:

#### Jean Stewart

##### New Member
Thanks the formula is quite complicated ... I don't want to sound ungrateful but its there a simpler formula?

#### Jean Stewart

##### New Member
hi Jean ......
You can Use This Formula
Code:
``=\$A2+(\$A2*B\$1)``
I think this is the simplest equation that can be used
I used =E3*1.01 and its ok I think ;-) thanks for your help