Hi, does anybody know if it is possible to have a nested =IF formula, with AND and OR options? Or does AND always only provide a TRUE and FALSE return?
I am basically trying to say;
'If cell A,B,C,D contains something specific, and cell E contains either X or Y, then do this...'
It's a meaty...