Hi there all, sorry I just cant get my head around nested ifs??
I have two columns I and K and the following criteria with desired return
for the formula:
I and K can be one of these values €œN/C€�, €œStart€�, €œStop€�, €œInc€�, €œDec€�,
€œBLANK€�, €œC/R€�
Depending on the combination of I and K, I want to return either €œYes€� or
€˜No€�.
Here are the I and K = outcome options:
N/C and N/C = Yes
N/C and Start= Yes
N/C and Stop = No
N/C and Inc = Yes
N/C and Dec = Yes
N/C and BLANK= Yes
N/C and C/R = Yes
BLANK and BLANK = No
Start and N/C= No
Start and Stop = No
Stop and N/C= Yes
Inc and N/C=Yes
Inc and Dec= Yes

There are more!

Can i combine all of the €˜Yes options? Whats the best or easiest way to
deal with this? Many thanks Theo.