Nested If Using TODAY Function

R

Robbie

I'm having issues with a nested IF using the TODAY function. Basically, in
one worksheet I enter the training date in DD-MMM-YY format or a "P" for "In
Progress." However, the "P" works for copying into another worksheet, but
having an empty cell or the date will give me the task length. Here's my
formula:

=IF(AADO!B13="P","P",IF(AADO!B13<=TODAY(),1.75,""))

If the cell, AADO!B13, equals "P" the "P" appears in AADOHours!B13.
However, if the cell is empty or has the training date, the task length, 1.75
hours, is entered. The end result I'm looking for is if the cell, AADO!B13
(for example) is empty, then I would like AADOHours!B13 to remain empty until
"P" is entered or the training date.

Thanks, Robbie
 
M

Max

Try strapping on an additional IF check upfront:
=IF(AADO!B13="","",IF(AADO!B13="P","P",IF(AADO!B13<=TODAY(),1.75,"")))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF statement help 5
1st Wed, 1st Sat, 1st Sun 5
copy worksheet to another worksheet 2
Cell addressing using the content of another cell. 1
Cell addressing using the content of another cell. 5
IF / OR Function 7
If(and) function 5
Need Excel Formula to complete Function 2

Top