Need help with this function statement. Not sure if I can use a if(or, or a if(and(or
=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))))))))))))))
I still have more values to add but I ran out of space. Just trying to clean it up so I can add more parameters. Thanks. … Carl
=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)))))))))))))) I still have more values to add but I ran out of space. Just trying to clean it up so I can add more parameters. Thanks. … Carl Read More