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

mrcarlyoungblood 

Other functions that make the formula more readable are IFS and SWITCH.

=SWITCH(
    string,
    "CEL", altValue  + 30,
    "AZA", altValue  + 30,
    "CUN", altValue  + 30,
    "LIN", baseValue + 60,
    "EXP", baseValue + 60,
    "CYL", baseValue + 30,
    "GLO", baseValue + 30,
    "MSC", baseValue + 30,
    "SIL", baseValue + 30,
    "TAU", baseValue + 30,
    "SHL", baseValue + 45,
    "SCE", baseValue + 45,
    "SEA", altValue  + 45,
    "NOR", altValue  + 14
)

(the use of defined names highlighted an inconsistency in your original formula).

Sergei's ideas of grouping data or having it in a lookup table are both worth consideration.

mrcarlyoungblood 

One variant as OliverScheurich  suggested

=IF( OR( J2 = {"CEL","AZA","CUN"} ),       N2+30,
 IF( OR( J2 = {"LIN","EXP"} ),             L2+60,
 IF( OR( J2 = {"GLO","MSC","SIL","TAU"} ), L2+30,
 IF( OR( J2 = {"SHL","SCE"} ),             L2+45,
 IF(     J2 =  "SEA",                      N2+45,
 IF(     J2 =  "NOR",                      N2+14
))))))

Another variant create the table tbl like

and use formula

=LET(
  l, XLOOKUP(J2, tbl[J], tbl[L]),
  n, XLOOKUP(J2, tbl[J], tbl[N]),
  IF(l, L2+l, N2+n)
)