In excel i need to create a function that goes =C(1+2) +7, meaning =C3 +7. How can you do this? Has it a name?

Question

In excel i need to create a function that goes =C(1+2) +7, meaning =C3 +7. How can you do this? Has this function got a name? Thanks for your help!

Answer 1

Use INDIRECT function

= INDIRECT("C" & (1+2))+7

to make it more dynamic say 1 is in D1 a 2 is in E1

= INDIRECT("C" & (D1+E1))+7

Then you can change D1 and/or E1 to determine which row in column should add to 7.

Hope this helps.