Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet Function | Excel Discussion (Misc queries) | |||
Help with worksheet function | Excel Worksheet Functions | |||
Get a Worksheet name through a function | Excel Worksheet Functions | |||
Reference the worksheet from a multiple worksheet range function ( | Excel Worksheet Functions | |||
Can the offset worksheet function reference another worksheet | Excel Worksheet Functions |