Thread: Checks whether a value is text or number
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike Mike is offline
external usenet poster
  
Posts: 3,101
Default Checks whether a value is text or number
Try this

=IF(ISTEXT(A1),"True",IF(ISNUMBER(A1),"False","Its not a number or text"))

"robertc" wrote:

I want to make a function which returns a value if an entry is text and
another value if the entry is a number.

For example:

If A1=text, "True", If A1=number, "False
Reply With QuoteReply With Quote