About Us

Don Guillett

Glad to help

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Mario" wrote in message
...
Cool. This is what I wanted. Many thanks. :-)

"Don Guillett" wrote:

If you wanted to put your value in cell e1
=MIN(INDIRECT("A10:B"&E1))
or
=MIN(INDIRECT("A10:B"&E1+20))
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Mario" wrote in message
...
Hi there,

I would like to know how to add variable to arguments. E.g.: If I want
to
write the formula =min(A10:B25), but instead of writing fixed cells, I
would
like somthing like =min(A10:B"X+20"), where I can set any value to X.
In
this
case, if I set X=10, I would like to know the minimun between A20 and
B30
(that is 10 + 20).

Thanks.
Mario

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
variable height variable width stacked bar charts	ambthiru	Charts and Charting in Excel	3	January 18th 06 11:41 PM
Passing Variable Number of Arguments to a Sub	blatham	Excel Discussion (Misc queries)	4	December 10th 05 10:36 AM
Sum cells based on a row variable and seperate column variable	CheeseHeadTransplant	Excel Worksheet Functions	10	September 23rd 05 06:59 PM
object variable or with block variable not set	Diego	Excel Discussion (Misc queries)	1	August 9th 05 02:46 PM
why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel?	Daniel	Excel Worksheet Functions	1	July 9th 05 03:05 AM