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.
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.