Adding a set percentage to a figure in seperate column

[ScampsDad]

Second of the day, I'm on a roll!

I need to apply a 25% increase to an existing column of figures to the next column along. Lets say in A1 for example I have 400 but I want to add 25% to this to show in A2 as a total.

Ive tried using =A1+25% IN A2 but I am getting 400.25 as a result. Would someone be kind enought to explain where I am going wrong.

Many thanks

[kev_]

=A1*1.25
Should work

[JohnTopley]

In A2

=A1*(1+25%)

OR

=A1*(1.25)

[modytrane]

try:

=A1*1.25

[ScampsDad]

Certainly does Kev.

Thank you very much