If Unction with text

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

Glenn

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)))
 
H

Harlan Grove

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
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
Formula not updating 2

Top