Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem with Formula
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Problem | Excel Discussion (Misc queries) | |||
problem with the formula? | Excel Worksheet Functions | |||
IF Formula problem | Excel Worksheet Functions | |||
Formula Problem | Excel Discussion (Misc queries) | |||
formula problem | Excel Discussion (Misc queries) |