I want to use a formula that says if cells in column H are greater than 12 in value, then give me "yes" if not give me "no". My formula: =IF(H2">="&12,"YES","NO") It is showing this error: Not trying to type a formula? When the first character is an equal (=) or minus (-) sign, Excel thinks it's a formula: you type: =1+1, cell shows: 2 To get around this, type an apostrophe ( ' ) first: you type: '=1+1, cell shows: =1+1
Solved by A. L. in 30 mins