If formula

[abduldrda]

Hello everyone. I have the following question. I have male & female data in my excel sheet containing the marital status. I have to find out whether they married to
same caste people or other caste people. I needed formula both in Excel 365 and earlier versions of excel.

IF

$A$1 = ”BC-A” or ”BC-B” or ”BC-C” or ”BC-D” or ”BC-E”
$B$1 = ”BC-A” or ”BC-B” or ”BC-C” or ”BC-D” or ”BC-E”
Answer needed in $C$1 “SAME CASTE”

IF
$A$1 = “OC” $B$1=”OC” Answer needed in $C$1 “SAME CASTE”
$A$1 = ”SC” $B$1= ”SC” Answer needed in $C$1 “SAME CASTE”
$A$1 = ”ST” $B$1= ”ST” Answer needed in $C$1 “SAME CASTE”


IF
$A$1 = “OC” $B$1=”BC” or any other category. Answer needed in $C$1 “OTHER CASTE”

Thank you.

 

[ExceLoki]

try this

=IF(LEFT(A1,2)=LEFT(B1,2),"Same Caste","OtherCaste")