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