nested If
Try this:
=IF(I5="","",IF(J5="","In Progress","Closed"))
HTH
Elkar
"Dave Shultz" wrote:
Heres 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???
|