Forum Discussion
MartinBreeze
Mar 04, 2025Copper Contributor
how to refer the cell text as a parameter ?
Hello,
I need to make some calculations like below.
How can I make the cell text as a function parameter ?
I used "cell()" function but it doesn't work like I wanted.
I want to change parameters from C8 to G8 automatically when I change C3.
Regards.
Use the INDIRECT function in stead.
Like this: =MAX(INDIRECT(C3))
2 Replies
- MartinBreezeCopper Contributor
Thank you so much. 😄
- Riny_van_EekelenPlatinum Contributor
Use the INDIRECT function in stead.
Like this: =MAX(INDIRECT(C3))