In a formula that’s more relevant to Excel: If this cell, A1, is equal to 1, then cell B1 will equal 2, otherwise cell B1 will equal 3.

If you want to check if two values are not equal, use the special Excel not equal notation, which is made from the less than and greater than symbols, such as =B25.