You are probably thinking of the ISTEXT function?
--
David Biddulph

"diggyroo" wrote in message
...
I need to write an if function that says when text is enterd in a cell it
needs to return "please enter a value!!!" I cant remember how to define
text
in the if function. example. if(A1="text","Please enter a value!!!") I
need
it to say that if anything other than a # is entered in the cell beside
it.
And ive tried the one i put here and it only works if i put the word text
in
the cell.

Thanks for any help