Using IF function to display Null field

[rockycj]

I would like to be able to show a Blank or empty field if the Net Sales $ are Null. The user will enter the Freight $ and the Net Sales $ at the bottom and the calculation is above this month by month. So if nothing is entered for February 2008, I want that column for Freight$ per Net Sales $ (%) to show as Blank or Null.

Attached is an example. Thank you.

CC

[NBVC]

Try:

=IF(B8="","", B7/B8)

[rockycj]

Thanks that worked! I like your smurf.