| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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??? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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??? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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??? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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??? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nested IF | Excel Worksheet Functions | |||
| Nested If | Excel Worksheet Functions | |||
| nested if based on nested if in seperate sheet. how? | Excel Worksheet Functions | |||
| using nested OR | Excel Worksheet Functions | |||
| nested if | Excel Worksheet Functions | |||
Linear Mode
