If Unction with text
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 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(ISBLANK(Q11),"",IF(ISTEXT(Q11),Q11,IF(Q11=0,"M IN",Q11*2.54))) |
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))) |
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)) |
All times are GMT +1. The time now is 11:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com