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.