You can also opt for the XOR function, which, in its simplest form, returns TRUE if only one is TRUE, or FALSE if both values are TRUE. I use IFERROR to keep all my spreadsheets tidy. After all ...