I canot figure out why this won't work--the first fornula does not work, but
the second one does--I included both so that you could see what I have
changed

=SUM(IF(OR(F16="ca",F16="HBC"),(B42*9.5)*1.5,B42*9 .5))+G16*1.25+H16*1.25+E16/1.5)+IF(OR(F16="TT",C42/B42<7),C42*1.2,C42*1.05)+IF(F16="CA",C42*3.5)



This one works:



=SUM(IF(F14="ca",(B40*9.5)*1.5,B40*9.5)+G14*1.25+H 14*1.25+E14/1.5)+IF(OR(F14="TT",C40/B40<7),C40*1.2,C40*1.05)+IF(F14="CA",C40*3.5)



TIA