Excel Tutorial – IFS

Excel is a powerful tool that allows you to perform a wide range of calculations, including making decisions based on multiple conditions. The IFS function is a useful function in Excel that allows you to test multiple conditions and return a value based on the first condition that is met.

To use the IFS function, you will need to follow these steps:

1. Select the cell where you want the result of the IFS function to appear.
2. Type “=IFS(” (without the quotes) into the cell.
3. Specify the first condition that you want to test. This should be a logical test that returns either TRUE or FALSE.
4. Type a comma and then specify the value that you want to return if the condition is met.
5. Repeat steps 3 and 4 for each additional condition that you want to test.
6. Close the parenthesis by typing “)”.

For example, if you wanted to test if the value in cell A1 is greater than 10, and if it is, return “Greater than 10”, you could use the following formula: “=IFS(A1>10, “Greater than 10″)”.

If you wanted to test multiple conditions, you could use the following formula: “=IFS(A1>10, “Greater than 10”, A1<5, “Less than 5”, A1=7, “Equal to 7″)”. This formula will test if the value in cell A1 is greater than 10. If it is, it will return “Greater than 10”. If it is not, it will then test if the value is less than 5. If it is, it will return “Less than 5”. If it is not, it will then test if the value is equal to 7. If it is, it will return “Equal to 7”. If none of the conditions are met, the IFS function will return an error.

You can also use the IFS function to test conditions based on the values in multiple cells. For example, if you wanted to test if the value in cell A1 is greater than the value in cell B1, you could use the following formula: “=IFS(A1>B1, “Greater”, B1>A1, “Less”)”. This will return “Greater” if the value in cell A1 is greater than the value in cell B1, and “Less” if the value in cell B1 is greater than the value in cell A1.

I hope this tutorial has been helpful in understanding how to use the IFS function in Excel.