worksheet function

[lena_form]

Hello!
I have the formula:
if(or(sum(Quant.)=0;sum(price)=0);0;vlookup(sum(Quant.);L26:M29;2))
but is not that result that i want
Quant. and price are names for cells groups
Quant. = A16:A37
Price = H16:H37
I want that the the result of the formula just change when the cell of
quant. and the cell of price in the same row is whit a value

thank you
Helena Carona

 

[Max]

Maybe you're looking for something like this:
=IF(COUNT(A16,H16)<2,0,VLOOKUP(A16,$L$26:$M$29,2))

where the front: IF(COUNT(A16,H16)<2,0, .. part of it will ensure that
there's numbers in both cols A and H before evaluating the vlookup, otherwise
it'll just return a zero.

(Adjust the comma separators to semicolons to suit your version)

 

[lena_form]

Hello Max,

thank you with the solution. It's perfect.


HC


"Max" escreveu:

 

[Max]

welcome, Helena