Wednesday, February 8, 2012

Can i calculate percentage increase using excel?

using excel, for example how would is there a way to quickly work out what 8% on 20.99 would be? for use with things like price lists, therefore doing loads of prices at once?Can i calculate percentage increase using excel?
=20.99*8%



or if you have those in a list do



=A1*8%

or

=A1*0.08



assuming A1 has the 20.99, A2 has another, A3 has another and so on



the just copy and paste it down



You can also put 8% in cell D1, and paste this in B1

=A1*$C$1



and copy it down



VBAXLMan is back

No comments:

Post a Comment