| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I nest ISTEXT and IF functions?
I am sure this is probably simple and obvious, but I'm no Execl expert! I am
trying to make a cell return the value of 1 if true, 0 if false if another cell (in another workbook) contains text. I can't seem to get IF and ISTEXT to nest and I really don't want to have to create an entire separate range of cells to perform the functions separately. Thanks in advance for your help/advice. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| Data Validation preventing ISTEXT() from reading FALSE in '97 | Excel Discussion (Misc queries) | |||
| ISTEXT | Excel Discussion (Misc queries) | |||
| I need help with a =sum IF ISTEXT formula. I keep getting 0. | Excel Discussion (Misc queries) | |||
Threaded Mode
