Compare two cells in different columns, return value based on multiple conditions

[Beeftank]

Hello,

I have 3 columns E, F, and G. The cells in columns F and G are formula based that reference another worksheet. They either return an error or a text value.

I need a formula in E3 that will look at F3 and G3 and return a value based on the following conditions:

If F3 and G3 are both errors, show nothing
If F3=G3, show F3
If F3 is an error, but G3 is any text value, show G3
If G3 is an error, but F3 is any text value, show F3

Of note, if both F3 and G3 have text values, they will always be the same value. Below is what I have tried which works in the cases of F3=G3 as well as F3 and G3 both being errors, but not for any other condition.

=IF(AND(ISERROR(F3),ISERROR(G3)),"",IF(F3=G3,F3,IF(AND(ISERROR(F3),ISTEXT(G3)),G3,IF(AND(ISERROR(G3),ISTEXT(F3)),F3,""))))

I appreciate the help in advanced!

 

[DanteAmor]

Try this

=IF(ISERROR(F3),SI(ISERROR(G3),"",G3),F3)

 

[Beeftank]

Thank you DanteAmor!

This was a far more simplified solution than what I came up with and got the job done. Thanks again!

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.

 

[Peter_SSs]

This was a far more simplified solution than what I came up with ..

Her is a slightly simpler (that is, two less functions required) one again.

=IFERROR(F3,IFERROR(G3,""))