Function IF (IF) can be nested when multiple conditions need to be checked at the same time. Meaning FALSE (FALSE) may change to something else if the function continues checking. For an example, look at the formula below:
=IF(A1=1,"Bad",IF(A1=2,"Good",IF(A1=3,"Exellent","No Valid Score")))
=ЕСЛИ(A1=1;"Bad";ЕСЛИ(A1=2;"Good";ЕСЛИ(A1=3;"Exellent";"No Valid Score")))
- If the value in the cell A1 equally 1, the function returns Bath.
- If the value in the cell A1 equally 2, the function returns Good.
- If the value in the cell A1 equally 3, the function returns Excellent.
- If cell A1 takes on a different value, the function returns No Valid Score.
Here is another example:
=IF(A1<=10,350,IF(A1<=20,700,IF(A1<=30,1400,2000)))
=ЕСЛИ(A1<=10;350;ЕСЛИ(A1<=20;700;ЕСЛИ(A1<=30;1400;2000)))
- If the value in the cell A1 less or equal 10, the function returns 350.
- If the value in the cell A1 more than 10, but less than or equal to 20, the function returns 700.
- If the value in the cell A1 more than 20, but less than or equal to 30, the function returns 1400.
- If the value in the cell A1 more than 30, the function returns 2000.
Note: Perhaps in your formula you want to use "<"Instead of"<=“to change the boundaries a bit.