ExcelBanter - Concatenating two conditions in a "IF" Formula.

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Concatenating two conditions in a "IF" Formula. (https://www.excelbanter.com/new-users-excel/4558-concatenating-two-conditions-%22if%22-formula.html)

ringo tan

Concatenating two conditions in a "IF" Formula.

Hi,

Can anyone advice me how to concatenate two conditions in a "IF" formula?

Thanks and regards.

Ringo

Frank Kabel

Hi
do you mean something like
=IF(AND(A1=1,B1=2),"Match","no match")

--
Regards
Frank Kabel
Frankfurt, Germany

"ringo tan" schrieb im Newsbeitrag
...
Hi,

Can anyone advice me how to concatenate two conditions in a "IF"
formula?

Thanks and regards.

Ringo

CLR

Maybe.....

=IF(AND(A1=1,B1=2),CONCATENATE(A1,B1),"")

Vaya con Dios,
Chuck, CABGx3

"ringo tan" wrote:

Hi,

Can anyone advice me how to concatenate two conditions in a "IF" formula?

Thanks and regards.

Ringo

All times are GMT +1. The time now is 07:54 PM.