{"id":237,"date":"2014-09-24T00:50:51","date_gmt":"2014-09-23T22:50:51","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=237"},"modified":"2024-06-03T03:55:40","modified_gmt":"2024-06-03T01:55:40","slug":"if-function-combined-with-the-and-function","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/if-function-combined-with-the-and-function\/","title":{"rendered":"IF Function Combined With The AND Function"},"content":{"rendered":"

What does it do? <\/strong><\/em><\/p>\n

It returns a value that you set if a condition is met, and a value if it is not met<\/p>\n

Formula breakdown: <\/strong><\/em><\/p>\n

=IF(AND(Logical Test<\/span>),Value if True<\/span>,Value if False<\/span>)<\/p>\n

What it means: <\/strong><\/em><\/p>\n

=IF((Sales are bigger than $3000 & in the North region<\/span>),“Bonus”<\/span>,“No Bonus”<\/span>)<\/p>\n

\n

When combining (or nesting) the AND function with the IF function<\/a><\/strong>, it allows you to add more than one condition to your formula, something that is not possible with the IF function by itself.<\/p>\n

So you can show the results of Sales Reps that have made more than $3,000 of sales AND who are part of the North region, as explained below…<\/p>\n

\n

Download excel workbook<\/i><\/span>If_And.xlsx<\/span><\/a><\/p>\n<\/div>\n

We want to show a Bonus value if sales are bigger than $3000 and comes from the North region, and No Bonus is shown if this condition is not met.<\/p>\n

STEP 1:<\/strong><\/span> We need to enter the IF function<\/strong> in a blank cell:
\n=IF(<\/span><\/code>
\n\"IF<\/p>\n

 <\/p>\n

STEP 2:<\/strong><\/span> The IF<\/strong> arguments:<\/p>\n

\n
\n

Table of Contents<\/p>\n<\/span><\/div>\n