"zSplash" wrote...
What I need to do is something like this:

=IF(B15<"",IF(D15<""+OR(F15<"",IF(F15="H",B15, IF(F15="W","",IF(F15="SPLIT
",B15/2,IF(F15="DIVIDE",B15/2,IF(F15="50/50",B15/2,"")))))),B15*D15,""))
...

...IF(D15<""+OR(F15<"",IF(F15="H",...

is almost certainly not what you want, though it's syntactically valid. It looks
like you want the result to be "" if B15 = "", D15 = "" and F15 = "" or none of
"H", "SPLIT", "DIVIDE" or "50/50". If so, try

=IF(B15="","",IF(OR(F15={"SPLIT","DIVIDE","50/50"}),B15/2,IF(F15="H",B15,
IF(AND(D15<"",F15=""),B15*D15,""))))

--
To top-post is human, to bottom-post and snip is sublime.