If statement issue

[Monjavz]

I need help please, I have various conditions and got this far

=IF(AND(W687>0;X686>0);(W687*Y687*G687)+X686*Y687*G687;0)

only problem is that if cell W687 is negative it should still perform the calculation for X686 if this cell is positive.

How can I change the formula to do this.

Thank you very much

 

[Monjavz]

for the first line and using the provided data how is that calculated?

=+(w192*(x193-1))*g193+(w193*1*g193)
=2065.72*(7-1))*0.80+(1965.70*1*0.80)

 

[Monjavz]

The incorrect line is calculated with this formal
=IF(OR(V193>0;W192>0;V193<0);(V193*X193*G193)+W192*X193*G193;0)

 

[steve the fish]

This produces the same answers as your answers far as i can tell. Im not sure what the *1 is for?

=IF(X3>0,(W2*(X3-1)*G3)+(W3*G3),0)

 

[Monjavz]

This produces the same answers as your answers far as i can tell. Im not sure what the *1 is for?

=IF(X3>0,(W2*(X3-1)*G3)+(W3*G3),0)

It is to calculate 1 day

 

[Monjavz]

Thanks a mill just entered it into my sheet and it works perfectly!! MUCH APPRECIATED