Perhaps you need to use a semicolon rather than a comma - try it this
way:

=IF(A1="Single";1;2)

Hope this helps.

Pete

On Nov 15, 8:31*pm, Imani wrote:
If I create a function which checks for text in a cell, it gives a #NAME?
error.
I have a sheet with a cell containing the text 'Single'. In another cell I
want to check for that word so I type =if(a1=''Single'', 1,2). Is there
something wrong with that IF, it happens with any text I check for.