Nested IF statements

Hi Jens,

Hope you are well.

I have a query regarding nested IF statements in Excel and how to construct them. However I don't know where to begin or how to construct the layers, so to speak.

I posted my query on a public forum and was advised that it was 'complex' and would require several levels of nested IF statements. I can get the formula to work, but only if the expected outputs are either 'pass' or 'fail'. This is the formula:

=IF(OR(C2="N/A",D2="N/A",AND(B2="CERO",OR(D2="Yes",D2="No"))),"Pass","Fail")

However, I need a formula which can handle multiple fail conditions depending on different permutations of user input to cells B2, C2 & D2.

I'm hoping that if you copy and paste the bold text below into an Excel worksheet, it should put place these in an understandable grid format.



Formula goes in this column Obligation Sub Category Rural Area Rural Sub Obligation
Pass N/A
Fail - rural area must be N/A
Pass CERO Yes
Pass CERO No
Fail - rural sub obligation is invalid CERO any text input
Fail - rural sub obligation is blank CERO
Pass any text input N/A
Fail - rural sub obligation is blank any text input



If you provide any help or guidance on this it would be very much appreciated.

Best Regards,
Cal