IF AND ISTEXT ISBLANK formula

[SCrowley]

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(ISBLANK(EA6),ISTEXT(EB6)),EB6,IF(AND(ISTEXT(EA6),ISBLANK(EB6)),EA6,)))

 

[Sean Timmons]

the formula is entered as you were expecting. Not sure which error you're
getting. Try clicking on the fx vutton to see where you may be getting your
error...

 

[SCrowley]

Thank you, Sean. After poking around I found a hidden " ' " mark in the blank
cells. I did a Find and Replace as well as TRIM and CLEAN and neither one
removed the mark so I'm clearing contents of visually blank cells. Wow, I
actually wrote a working formula!!!

 

[T. Valko]

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.

 

[Sean Timmons]

I guess that's a good thing.

Not sure why a find/replace wouldn't have fixed the issue, unless it did too
much replacing....

 

[Sean Timmons]

Which would mean instead of ISBLANK, do EA=""

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.