how to make an if statement where one value equals another code example Example: if equal to excel =IF(A1="red",true result,false result)