Answer the question
In order to leave comments, you need to log in
How to write a formula with multiple IF(If)?
Good afternoon.
Please help me write the formula.
There is a Cell in which there can be two fixed values YES/NO.
I wrote a formula for the value YES:
=IF(IF(C2="YES"; E2>=250);"Passed";"Not done")
=IF(IF(C2="NO"; E2>=150);"Passed";"Not completed")
Answer the question
In order to leave comments, you need to log in
=IF(C2="ДА";IF(E2>=250;"Выполнен";"Не выполнен");IF(E2>=150;"Выполнен";"Не выполнен"))
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question