worksheet function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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)
 
Back
Top