Multiple IF compare two columns

**vinaynaran** · 01-11-2011, 06:24 AM

Dear all,

Please see attachment.

Actually I want to compare two columns depend on their criteria and print “OK” or “Check”

It would be very much appreciated if you could help me.

Thanks.

Vinay

**Richard Buttrey** · 01-11-2011, 06:43 AM

Hi,

How about

=IF(OR(AND(B2>=30,C2>=75),AND(B2>=11,B2<=29,C2>=35),AND(B2>=5,B2<=10,C2>=8),AND(B2>=0,B2<=4,C2<=7)),"OK","Check")

Rgds

**martindwilson** · 01-11-2011, 06:47 AM

i think this will do
=IF(AND(B2<5,C2<8),"ok",IF(AND(B2<11,C2>7),"ok",IF(AND(B2<30,C2>34),"ok",IF(AND(B2>29,C2>74),"ok","c heck"))))

**vinaynaran** · 01-11-2011, 06:55 AM

Thanks Martin & Richard,

Both are great.

It's working fine.

Thanks again.

Vinay

**spelton** · 06-24-2011, 03:22 PM

I need to check cell C10 to see if the number 06-10 is present (will appear as 06, 07 etc), and if so, check that another cell D15>=2, and if so enter Pass in cell D16, otherwise Fail. However, if the number in C10 is 11-15, I need it to check that D15>=1, and if so enter Pass in cell D16, otherwise Fail.
Is that a formula that can look at the number in C10, and based on this number, compare the correct acceptance criteria to return Pass/Fail?

Thanks
SP

**NBVC** · 06-24-2011, 03:24 PM

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.