Combine IF with AND to check several conditions - Logical Functions - Microsoft Excel Tutorials

7.  Combine IF with AND to check several conditions:


In this example, Excel evaluates which condition meets the criteria and returns the result in the same row.

To combine the IF and AND functions:

1. Copy the content of cells C2 to C5 in Figure 2-7 to your Excel table.
2. Frame the table as shown in the screenshot
3. Select cell A2 and enter any kind of sales value, e.g., 120.
4. In cell B2, type the following formula: =IF(AND($A$2<=100,$A$2""),"Sales value is","").
5. In cell B3, type the following formula: =IF(AND($A$2>100,$A$2<=150)," Sales value is ","").
6. In cell B4, type the following formula: =IF(AND($A$2>150,$A$2<=200)," Sales value is ","").
7. In cell B5, type the following formula: =IF($A$2>200,"Sales value is ","").

Watch the Video Tutorial - https://www.youtube.com/watch?v=unjOBizKavM

  Hope You Like This Tutorials - Give Comments