Basic Excel IF with AND Condition (Multiple Conditions in IF)
Basic Excel – IF with And Function
What Does It Do?
This function tests two or more conditions to see if they are all true.
• It can be used to test that a series of numbers meet certain conditions.
• It can be used to test that a number or a date falls between an upper and lower limit.
Normally the AND() function would be used in conjunction with a function such as =IF().
Syntax
=IF(AND(Test1, Test2),True Action, False Action)
Note that there can be up to 30 possible tests.
For Online Traning
Excel, Power BI, SQL Server, Postgre SQL, Azure, Sharepoint, Tableau, SSIS Etc
you can contact on below Contact Details
WhatsApp - +49 17636191639
Email - [email protected]