Which is the correct approach for when we want to have Excel evaluate an IF statement for 2 different logic conditions? (for example B25 and B2

Question

Which is the correct approach for when we want to have Excel evaluate an IF statement for 2 different logic conditions? (for example B2>5 and B2<10).

Answer

=IF((logic_1, AND(IF logic_2)), value_if_true, value_if_false)

Answer

=AND(IF(logic_1, logic_2), value_if_true, value_if_false)

Answer

=IF((logic_1 AND logic_2), value_if_true, value_if_false)

Answer

=IF(AND(logic_1, logic_2), value_if_true, value_if_false)

Crowdly