| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF AND ISTEXT ISBLANK formula
I have two columns EA and EB, if EA istext and EB istext then EB, AND if EA
isblank and EB istext then EB, AND if EA istext and EB isblank then EA. I wrote the formula below but it isn't returning values as I thought I had written it. Your help is greatly appreciated. =IF(AND(ISTEXT(EA6),ISTEXT(EB6)),EB6,IF(AND(ISBLAN K(EA6),ISTEXT(EB6)),EB6,IF(AND(ISTEXT(EA6),ISBLANK (EB6)),EA6,))) -- Thank you, scrowley(AT)littleonline.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Blank cells: ISBLANK = FALSE, ISTEXT = TRUE | Excel Worksheet Functions | |||
| IF(ISTEXT Concatenate formula question | Excel Worksheet Functions | |||
| IF-ISTEXT formula | Excel Discussion (Misc queries) | |||
| ISTEXT TRUE then copy formula from cell X | Excel Worksheet Functions | |||
| I need help with a =sum IF ISTEXT formula. I keep getting 0. | Excel Discussion (Misc queries) | |||
Threaded Mode
