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
--
Michael Robinson

Try strapping on an additional IF check upfront:
=IF(AADO!B13="","",IF(AADO!B13="P","P",IF(AADO!B13 <=TODAY(),1.75,"")))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Robbie" wrote:
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
--
Michael Robinson

Max, you rock! Thanks, dude!
--
Michael Robinson


"Max" wrote:

Try strapping on an additional IF check upfront:
=IF(AADO!B13="","",IF(AADO!B13="P","P",IF(AADO!B13 <=TODAY(),1.75,"")))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Robbie" wrote:
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
--
Michael Robinson

Welcome, Michael.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Robbie" wrote in message
...
Max, you rock! Thanks, dude!
--
Michael Robinson