Problem with Formula

[Steve M]

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+H14*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

 

[joeu2004]

I canot figure out why this won't work--the first fornula
does not work, but the second one does [....]

=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+H14*1.25+E14/1.5)
+IF(OR(F14="TT",C40/B40<7),C40*1.2,C40*1.05)
+IF(F14="CA",C40*3.5)

Don't know what you mean by "works" and "won't work". But the first
formula has a syntax error: double right-parenthesis after the second
B42*9.5.