Alright, thanks for the input everybody, but I have the
answer. =IF(C1=0,0,40.00)

(Well basically, the 40.00 actually comes from a link in
another sheet). Anyway, if I use the zeroes in the
formula rather than the " ", everything works perfectly!

Thanks again!
-----Original Message-----
I've made this work many years ago but now can't
remember
how. I have a job invoice to where the rate is
40.00/hour. This 40.00 is used in calculation to
determine the total amount of pay owed. (20 hours worked
* 40.00/hour). The boss requires that the hourly rate
be
shown for each job on the invoice, so that means it is
in
a column to where the amount is repeated all the way
down. All I want is for the contents of that particular
column NOT to show (show as blank), if no job has been
entered. In other words, if there is no data entered on
that particular row, hide the contents of the cell the
hourly rate is shown in. Does anybody know how to do
this? Thanks!
.