Hi
in B1 enter
=A1*0.8
and copy this formula down

--
Regards
Frank Kabel
Frankfurt, Germany

sapphria wrote:
How do I multiply a row or column of numbers by the same number ie,
a1,a2,a3,a4 etc by .8 and have all the answers displayed on the
worksheet?