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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment