Thread
:
Display constant cell value based on another cell value
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
Chip Pearson
external usenet poster
Posts: 7,247
Display constant cell value based on another cell value
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!
Reply With Quote
Chip Pearson
View Public Profile
Find all posts by Chip Pearson