Try this one: suppose the hourly rate cell is in cell C10. Suppose the
job description cell is B10. One way to do this is enter this formula
in C10:
=IF(B10="","",40)

This enters a blank value if B10 is blank, and populates it with 40 if
the job is filled in. Does that do it?