Adjusting a Formula

[Excel_77]

Hi,

The below formula is suppose to check column A for vaues below 1000 and B for values below 500 an if true want "Yes" retunred otherwise ant "No" returned. I want to adust the formula so that B2 only returns values over 1 as well as those under 500, how can this be done?

=IF(AND(A2<1000,B2<500),"Yes","No")

 

[Joe4]

You can just keeping adding clauses to your existing AND function, i.e.

[COLOR=#333333]=IF(AND(A2<1000,B2<500,[/COLOR][COLOR=#ff0000]B2>1[/COLOR][COLOR=#333333]),"Yes","No")[/COLOR]

I think you can have up to 32 arguments in your AND function.