Adjusting a Formula

Excel_77

Active Member
Joined
Sep 15, 2016
Messages
289
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

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
51,514
Office Version
365
Platform
Windows
You can just keeping adding clauses to your existing AND function, i.e.
Code:
[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.
 

Forum statistics

Threads
1,082,641
Messages
5,366,717
Members
400,915
Latest member
NFlem

Some videos you may like

This Week's Hot Topics

Top