D
D
Denis Davydenko2018-08-18 17:30:57
Spreadsheets
Denis Davydenko, 2018-08-18 17:30:57

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")

Formula for NO value:
=IF(IF(C2="NO"; E2>=150);"Passed";"Not completed")

How to combine them into one formula?

Answer the question

In order to leave comments, you need to log in

2 answer(s)
S
Saboteur, 2018-08-18
@GooseTheDestroyer

=IF(C2="ДА";IF(E2>=250;"Выполнен";"Не выполнен");IF(E2>=150;"Выполнен";"Не выполнен"))

A
Aleksandr, 2018-08-18
@alexgearbox

Fuck the old formula. New.

=IF(OR(AND(C2="Yes";E2>=250);AND(C2="No";E2>=150));"OK";"Bad")

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question