> > >

Excel MCQs

How can you write an IF statement so that it has more than one criterion?

Use two conditions for the first argument, separating them with commas.

Use a whole IF statement for the TRUE or FALSE argument (nesting one IF function inside another).

Use two conditions for the first argument, separating them with the pipe character: |

Use two conditions for the first argument, separating them with the OR keyword.

Answer

Correct Answer: Use a whole IF statement for the TRUE or FALSE argument (nesting one IF function inside another).

Explanation:

Note: This Question is unanswered, help us to find answer for this one

Excel Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it