Problem with Formula
On Mar 31, 6:43*am, "Steve M" wrote:
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.
|