Need help with this function statement. Not sure if I can use a if(or, or a if(and(or

mrcarlyoungblood 

=IF(J2="CEL",N2+30,

IF(J2="AZA",N2+30,

IF(J2="CUN",N2+30,

IF(J2="LIN",L2+60,

IF(J2="EXP",L2+60,

IF(J2="CYL",L2+30,

IF(J2="GLO",L2+30,

IF(J2="MSC",L2+30,

IF(J2="SIL",L2+30,

IF(J2="TAU",L2+30,

IF(L2="SHL",L2+45,

IF(J2="SCE",L2+45,

IF(J2="SEA",N2+45,

IF(J2="NOR",N2+14))))))))))))))

With OR you can use the below formula.

=IF(OR(J2="CEL",J2="AZA",J2="CUN"),N2+30,

IF(OR(J2="LIN",J2="EXP"),L2+60,

IF(OR(J2="CYL",J2="GLO",J2="MSC",J2="SIL",J2="TAU"),L2+30,

IF(OR(L2="SHL",J2="SCE"),L2+45,

IF(J2="SEA",N2+45,

IF(J2="NOR",N2+14))))))