Posted to microsoft.public.excel.worksheet.functions

lena_form

external usenet poster

Posts: 8

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Worksheet Function	JeremyH1982	Excel Discussion (Misc queries)	4	May 9th 07 09:31 PM
Help with worksheet function	Jonas	Excel Worksheet Functions	0	November 29th 06 11:26 AM
Get a Worksheet name through a function	Tetsuya Oguma	Excel Worksheet Functions	2	March 10th 06 03:29 AM
Reference the worksheet from a multiple worksheet range function (	DBickel	Excel Worksheet Functions	1	May 28th 05 03:49 AM
Can the offset worksheet function reference another worksheet	AlistairJ	Excel Worksheet Functions	2	May 9th 05 06:18 PM

All times are GMT +1. The time now is 12:36 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us