if value is equal to text then excel code example Example: if equal to excel =IF(A1="red",true result,false result)