Nested If Statement

[Stroobs]

Hi,

I have the following nested if statement.

= IF(NSCs[@[SLP?]]="X",
IF(NSCs[@[SLP 1]]="X","Plan 1",
IF(NSCs[@[SLP 2]]="X","Plan 2",
IF(NSCs[@[SLP 3]]="X","Plan 4","not known"))))

which works fine.

However I need to do a check before the above to check for a blank in the SLP? field along the lines of the below.

= IF(ISBLANK(NSCs[@[SLP?]]),""," "),

So the order I need is:

If SLP? field is blank, leave the current cell blank.
Else if SLP? is not blank and SLP 1 has an X, put "Plan 1" in current cell.
Else if SLP? is not blank and SLP 2 has an X, put "Plan 2" in current cell.
Else if SLP? is not blank and SLP 3 has an X, put "Plan 4" in current cell.
Else put "not known" in the current cell.

I'm struggling of how to get the checks to work in the order I need so any help would be appreciated.

Thanks.

 

[Fluff]

How about

=IF(NSCs[@[SLP?]]="","",IF(NSCs[@SLP1]="X","Plan 1",IF(NSCs[@SLP2]="X","Plan 2",IF(NSCs[@SLP3]="X","Plan 4","not known"))))