Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Variable in arguments
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Variable in arguments
On Nov 16, 9:01 am, Mario wrote:
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 What you need is the indirect function: =min(indirect("A10:B" & X+ 20) hth Carlo |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Variable in arguments
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Variable in arguments
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
variable height variable width stacked bar charts | Charts and Charting in Excel | |||
Passing Variable Number of Arguments to a Sub | Excel Discussion (Misc queries) | |||
Sum cells based on a row variable and seperate column variable | Excel Worksheet Functions | |||
object variable or with block variable not set | Excel Discussion (Misc queries) | |||
why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? | Excel Worksheet Functions |