If a cell has any text at all, need formula

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.
 
L

Leo Heuser

Nancy

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

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

Nancy

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Page numbering with Merged Document and IF statements 1
Searching the formula (not the value) for a text string 1
Show a cell's formula in text format in a linked cell 2
Hide columns based on row values 2
Using FIND to highlight text (with dashes) 4
How can the font and size of (all) citation numbers be altered? 1
Visio shape text disappears upon copy paste 1
Excel Countif Function - Calculating Between Two Sets of Values 3

Top