IF or Product

[Stylus88]

Dear kind friends of mrexcel I have another problem that is keeping me stuck and I show you.

In an a cell the results is the product: =PRODUCT(Q109,J$3) In the same cellar I want also the condition =IF(U109>0, 0, IF(V109>0.5,0, IF(W109>0,0)))

So, I want to combinate this two different formulas: If the results of each cellar U109,V109,W109 is greater than 0,0.5,0 the results must be 0, if not the result is the product of Q109*J3

I tried with this but it doesn't work
=IF(U109>0,0,Q19*J$3 (IF(V109>0.5,0,Q19*J$3 (IF(W109>0,0,Q19*J$3)))))

 

[Fluff]

How about
=IF(AND(U109>0,V109>0.5,W109>0),0,Q109*J$3)