If those cells contain formulas that might return formula blanks ("") then
ISBLANK might not be doing what you think it's doing.

ISBLANK means "is empty". If a cell contains a formula blank then the cell
*isn't empty* and ISBLANK evaluates to FALSE.

Also, a formula blank is a *text string* so ISTEXT will evaluate to TRUE.

--
Biff
Microsoft Excel MVP


"SCrowley" wrote in message
...
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