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))
 
Back
Top