In B1 apply this formula and copy down
=IF(A1="","",A1*18.75)

--
Jacob


"Ach" wrote:

I want to be able to create totals in one column from entries in another
column. For example if a3=10 a7=8 a11=8. I want the corresponding rows in
column b to be multiplied by 18.75. ie . b3= a3*18.75 b7=a7*18.75
b11=a11*18.75