Check if a cell contains text

  • Thread starter Thread starter GreenMonster
  • Start date Start date
G

GreenMonster

I need to incorporate the function =ISTEXT(D5) into an existing if
statement. The existing if statement is

=IF(D5="One Panel","NA",IF(D5="Self Storing","NA","??"))

in my worksheet there will be times when cell D5 contains text and other
times when the cell contains nothing at all. When D5 contains nothing, I
need the cell recieving the if statment to also be left blank.

Make sense?

Thanks
 

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

Check the two different cells in the same row 2
change cell value by code 6
Prevent user input, if adjacent cell text is identical 6
check box value 6
Need a formula: If TIME is > or < than a cell enter TEXT 2
Need macro that analyses 2 columns . Delets row if same text is fo 3
Always keep first part of text in a cell 2
RecordHigh(Cell) 3

Back
Top