The syntax of XOR is similar to OR we just need to add X at the beginning. The action to perform if the condition is not met or is false. For example take a look at the IF function in cell C2 below.
For example to pass scores above 70.
The action to perform if the condition is not met or is false. Returns a value you specify if a formula evaluates to an error. For example to pass scores above 70. Enter the following formula that uses the IF function IF E4.