Excel IF condition formula help

[Izhar]

hello folks,

i have a 2 column with TRUE and FALSE

need your help with a formula to give me the proper number for the below key

true true - 1
true false - 2
false false - 3
false true - 4

Thanks,
Izhar

 

[bosco_yip]

C1, copied down :

=MATCH(0+A1&0+B1,{"11";"10";"00";"01"},0)

Regards
Bosco

 

[Izhar]

thank you Mr. Bosco, works like a dream.

Regards,
Izhar