If Unction with text
THANK YOU THANK YOU!!!
"Glenn" wrote:
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)))
|