Display constant cell value based on another cell value

[Guest]

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!

 

[Chip Pearson]

Try

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


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

 

[Guest]

Worked like a charm! Thanks!
For my knowledge, what does the "" do in a formula?

Blue Bunny

 

[Guest]

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(E2>0,$J$1,"") In J1 put 18. This seems to
be working well.

Blue Bunny

 

[Guest]

Hi again,

The "" is simply nothing. It is the Else part of the formula. The formula in
literal terms means if the value in E2 is greater than zero then insert the
value in cell $J$1 Else insert "".

If you want to insert a character like A then it has to be enclosed in
double quotes. By placing the double quotes together with nothing in between
then nothing is displayed.

Regards,

OssieMac

 

[Guest]

Thanks for the explanation. You've been so helpful. I'm in a new job and
utilizing new aspects of Excel - Excel continues to impress me with it's
capabilities! Hope I can contact you again when other challenges occur!!

Blue Bunny