If a cell has any text at all, need formula

  • Thread starter Thread starter Nancy
  • Start date Start date
N

Nancy

I need to create a formula within the same worksheet that
identifies if text appears in a certain cell. It is the
last cell in a list, and when it contains any text at all,
I want to print the word FULL in another location. I
can't seem to find the right formula to create.
 
Nancy

If you by "text" mean alfa-characters and
not numbers entered as text, here's one way:

=IF(ISERROR(B200+0),"FULL","")
 
That did it! Thank you!

-----Original Message-----
Nancy

If you by "text" mean alfa-characters and
not numbers entered as text, here's one way:

=IF(ISERROR(B200+0),"FULL","")

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

"Nancy" <[email protected]> skrev i en meddelelse


.
Click to expand...
 
Back
Top