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

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

2 ways:-

In C1 enter
=B1*5
Drag this down

Better is to enter yout $5 in another cell (say E1) and enter this in c1 and
drag down

=B1*E$1

The second ways allows you to multiply B by and value you enter in E1.

Mike
"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