Hope this helps some
Not knowing fully how your spreadsheet looks, so what I did is the following:
At my top, I have my inputs which I would change with my needs
I use Conditional Formatting to spot zeros
so with your formula, I did this
=IF(C6=0,(C3*C4*C5)*(C7+C8+C9),C3*C4*C5*(C6/C7+C8+C9))
which does NOT do a calculation with C6 if its value is a zero, BUT does a calculation without C6
Obviously, if I am in the ballpark with this solution, check carefully my formula
Hopes this helps to get you started
|