nested If
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??? |
nested If
=IF(I5="",IF(J5="","","result undefined"),IF(J5="","In Progress","Closed"))
-- David Biddulph "Dave Shultz" wrote in message ... 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??? |
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??? |
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??? |
All times are GMT +1. The time now is 02:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com