Alternative to nested IF functions in excel : Nominated Post

[ejfel01]

Instead of using obscure nested "if" statements, one could always use the built-in "and" logical operator.
It is used as =and(first_parameter; second_parameter, ...). "And" returns true, if all of its parameters are true.
=if(and(p1;p2;case when true;case when false).