Can i test 3 condition in a if(and function?

February 28, 2013 at 17:05:36
Specs: Windows 7

If(and(A>0,B<0,C=10,"Great Job"))

or are other functions more appropriate for this?


See More: Can i test 3 condition in a if(and function?

Report •

February 28, 2013 at 17:26:52
There's nothing wrong with using 3 conditions inside an AND, but you are missing the parenthesis to close the AND. You are also missing a value_if_false argument for the IF.

However, if you need to check all of the various combinations of A, B and C, then there might be a better way. I'm thinking a VLOOKUP table might work.

Can you supply some more details about what it is that you are trying to do?

If you plan to post any example data, please click on the following line and read the instructions found via that link. Thanks.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question