Yes, you can use two inequalities with the IF function in Excel.
To check if a value in cell E5 is between 10 and 20, you can use the following formula:
- =IF(AND(E510,E5<20),"Value is between 10 and 20","Value is not between 10 and 20")
Here, we have used the
AND function to check if both inequalities are true. If both are true, then the
IF function returns "Value is between 10 and 20", otherwise it returns "Value is not between 10 and 20".
Similarly, to check if a value in cell E9 is between 100 and 200, you can use the following formula:
- =IF(AND(E9100,E9<200),"Value is between 100 and 200","Value is not between 100 and 200")
Again, we have used the
AND function to check if both inequalities are true. If both are true, then the
IF function returns "Value is between 100 and 200", otherwise it returns "Value is not between 100 and 200".