simple forula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top