Thanks for the suggestion. I couldn't get this one to work, but maybe I'm
entering something wrong??? I truly appreciate you taking the time to help.

FYI: someone else suggested =IF(E20,$J$1,"") In J1 put 18. This seems to
be working well.

Blue Bunny

"Chip Pearson" wrote:

Try

=IF(E1="","",18)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)

"Blue Bunny" <Blue wrote in message
...
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!