Hi and welcome to the forum
Try this shorter version...
=if(OR(A1>21,A2>3),"NO","YES")
Also, test to see if the formula is returning exactly 21 or 3. It may be returning 2.99, formatted to look like 3 etc
edit: or yes, text, like jonmo suggests
Hi and welcome to the forum
Try this shorter version...
=if(OR(A1>21,A2>3),"NO","YES")
Also, test to see if the formula is returning exactly 21 or 3. It may be returning 2.99, formatted to look like 3 etc
edit: or yes, text, like jonmo suggests
Last edited by FDibbins; 11-04-2013 at 02:01 PM.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks