nested If
Perfect. Worked like a charm. You rock!
"Elkar" wrote:
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???
|