| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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))) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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))) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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)) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nested formula to search a text string and return specific text | Excel Worksheet Functions | |||
| grab cell text from multi-tab workbook, show text in another workb | Excel Worksheet Functions | |||
| Text does not display in "Text boxs" and when wrapping text in a c | Excel Discussion (Misc queries) | |||
| Text not continuing to wrap for large block of text in Excel cell | Charts and Charting in Excel | |||
| convert a range of lowercase text to upper text or vice versa | Excel Worksheet Functions | |||
Linear Mode
