nested If

D

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???
 
D

David Biddulph

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