Enter this formula in C1:

=IF(B1="","",B1*5)

Format the cell as currency and copy down column C as far as you need.

Hope this helps.

Pete

On Oct 4, 7:23 pm, cbazoo wrote:
ok, i feel real dippy here, I am simply trying to make each number i fill
into column B automatically multiply by $5 and fill this value into the colum
C cell next to it