Hi,

Assume that 18.00 is in cell J1.

=IF(E20,$J$1,"")

Regards,

OssieMac

"Blue Bunny" wrote:

I am setting up a time sheet template in Excel 2002. Below is the setup.

Col A Col B Col C Col D Col E Col F
Col G

Date Task Area Time In Time Out Hours Rate Amount Due
7:00 8:00 1.00 18.00 18.00

18.00
9:15 10:45 1.50 18.00 27.00
18.00
18.00
18.00
18.00
18.00
18.00
18.00
18.00
18.00
18.00
18.00
Invoice Total 2.50 18.00 45.00

I am wanting the rate of 18.00 (which is a constant) to only show in Column
F if there is a value in Col. E (same line).
Can this be done?

Thanks for any help provided!