Forum Discussion
Many criteria with ifs finction
Hi everyone! Can you help me to get this result guys, i tried but formula phase error seems. Attaching screenshot here in this msg.
I do not see an error message in the screenshot. But my guess is: the formula returns #N/A because none of the conditions applies.
At the very least, my guess is: the last condition should be AND(I3<E3,AP3>=I3,AO3="") or, better, simply TRUE.
IMHO, it is good practice to always have a TRUE last condition to catch everything that is not covered by the other explicit conditions.
Be that as it may, I wonder if your use of ="*" should be <>"". For example, AO3<>"" instead of AO3="*".
The latter only matches the character "*" (asterisk). It is not a wildcard that matches everything, if that is your intent.