If Unction with text

  • Thread starter Thread starter Deldridge
  • Start date Start date
D

Deldridge

This is my current formula.

=IF(ISBLANK(Q11),"",IF(Q11=0,"MIN",Q11*2.54))

I need to add another test to this formula that will look at the cell and if
it contains text, return whatever the text is.
 
Deldridge said:
This is my current formula.

=IF(ISBLANK(Q11),"",IF(Q11=0,"MIN",Q11*2.54))

I need to add another test to this formula that will look at the cell and if
it contains text, return whatever the text is.
Click to expand...


=IF(ISBLANK(Q11),"",IF(ISTEXT(Q11),Q11,IF(Q11=0,"MIN",Q11*2.54)))
 
Deldridge said:
This is my current formula.  

=IF(ISBLANK(Q11),"",IF(Q11=0,"MIN",Q11*2.54))

I need to add another test to this formula that will look at the cell and if
it contains text, return whatever the text is.
Click to expand...

If you treat Q11 as text, then blank Q11 would evaluate as "". So
better to turn this around.

=IF(COUNT(Q11),IF(Q11=0,"MIN",Q11*2.54),T(Q11))
 

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

If with countif or counta 3
If and Countif 2
Sumif where source values are assigned by "if" formula 3
Evaluating more than 30 conditions using a formula 1
Problems with Conditional Formatting 5
Help with negative number please 8
DATE as part of a formula 14
Finding a value in a Table 5

Back
Top