nested If

[Dave Shultz]

Here’s my dilemma:
If cell I5 is null and J5 is null, I want L5 to be null
If I5 is not null and J5 is null, I want L5 to return “In Progressâ€
If I5 is not null and J5 is not null, I want L5 to return “Closedâ€
Any suggestions???

 

[David Biddulph]

=IF(I5="",IF(J5="","","result undefined"),IF(J5="","In Progress","Closed"))

 

[Elkar]

Try this:

=IF(I5="","",IF(J5="","In Progress","Closed"))

HTH
Elkar

 

[Dave Shultz]

Perfect. Worked like a charm. You rock!

Try this:

=IF(I5="","",IF(J5="","In Progress","Closed"))

HTH
Elkar