I’m trying to set up an IF function to check data in a column and insert specific values in another. I’ve nested other OR and IF functions within it, but the data keeps returning true even if it is false. I don’t see any obvious errors. Any thoughts? This is my current function:

=IF(OR($C2:$C131=”ADMIN”,$C2:$C131=”PLANT”),”CAT1″,IF(OR($C2:$C131=”ENDO”,$C2:$C131=”ONC”,$C2:$C131=”VAS”,$C2:$C131=”PLASTIC”,$C2:$C131=”SURG”,$C2:$C131=”MIS”),”CAT2″,IF(OR($C2:$C131=”CARDIO”,$C2:$C131=”COLOR”,$C2:$C131=”LARY”,$C2:$C131=”TRUM”,),”CAT3″,” “)))

​I’m trying to set up an IF function to check data in a column and insert specific values in another. I’ve nested other OR and IF functions within it, but the data keeps returning true even if it is false. I don’t see any obvious errors. Any thoughts? This is my current function: =IF(OR($C2:$C131=”ADMIN”,$C2:$C131=”PLANT”),”CAT1″,IF(OR($C2:$C131=”ENDO”,$C2:$C131=”ONC”,$C2:$C131=”VAS”,$C2:$C131=”PLASTIC”,$C2:$C131=”SURG”,$C2:$C131=”MIS”),”CAT2″,IF(OR($C2:$C131=”CARDIO”,$C2:$C131=”COLOR”,$C2:$C131=”LARY”,$C2:$C131=”TRUM”,),”CAT3″,” “)))  Read More

​