hi,
very confusing.
some relevent date would have been helpful but i'll get
out the dart board.....
assuming that the rate in in column D and some type of job
id is in column A.....
=if(A2="","",hourlyRate)

-----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!
.