worksheet function
 

Hello!
I have the formula:
if(or(sum(Quant.)=0;sum(price)=0);0;vlookup(sum(Qu ant.);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

--
HC

worksheet function
 

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)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"lena_form" wrote:
Hello!
I have the formula:
if(or(sum(Quant.)=0;sum(price)=0);0;vlookup(sum(Qu ant.);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

--
HC

worksheet function
 

Hello Max,

thank you with the solution. It's perfect.


HC


"Max" escreveu:

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)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"lena_form" wrote:
Hello!
I have the formula:
if(or(sum(Quant.)=0;sum(price)=0);0;vlookup(sum(Qu ant.);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

--
HC

worksheet function
 

welcome, Helena
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"lena_form" wrote in message
...
Hello Max,

thank you with the solution. It's perfect.


HC