View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joeu2004 joeu2004 is offline
external usenet poster
 
Posts: 2,059
Default 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.