This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hi,
I wish to change quickly the border range of my function
=GROWTH(C14:C20,A14:A20,F2)
As input I'd pass A14 in cell E1, and then into growth function I'll get a range starting from A14 and covering 6 cells on the same column. The same about A14:20
Is it possible to do this?
Hi @Andrea Vironda ,
Do you mean you want to fix the range of A14:A20 and C14:C20? And the dynamic parameter is F2?
If yes try this function in E1:
=GROWTH($C$14:$C$20,$A$14:$A$20,F2)
If my understanding is incorrect, please provide a sample about this problem and I'm glad to help you.
If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hi,
no i wish to write on a cell "A14:A20" and pass it as an input to the main function GROWTH
Hi @Andrea Vironda ,
I cannot understand the meaning of write on a cell "A14:A20", is it possible to provide a sample about this problem?
You can upload a picture about the source table and the result table you need.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(246.4, 53%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi Andrea,
it seems to me that you need to use the INDIRECT function. If you put the range as a string in G1, and you want to pass it as the first parameter in the function GROWTH, your formula will be: "=GROWTH(INDIRECT(G1),A14:A20,F2)".
Of course you can use every kind of string as INDIRECT parameter. The formula "=GROWTH(INDIRECT("C14:C20"),A14:A20,F2)" should work as well.
I hope this is the answer you needed.
Kind regards,
Alex
