Four Outcomes using if statement

IF statement Returns one value if a condition you specify evaluates to TRUE and another value if it evaluates to FALSE. An if statement with four outcomes requires you to test three conditions The excel If () function is used to test a single condition that returns a value if the condition is met otherwise