View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove[_2_] Harlan Grove[_2_] is offline
external usenet poster
 
Posts: 1,231
Default If Unction with text

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


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