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(ISBLANK(Q11),"",IF(ISTEXT(Q11),Q11,IF(Q11=0,"M IN",Q11*2.54)))