How to Directly Adjust the Cell Reference Values Within the Formula?

My organization is working on an Shine in life formula although not sure how to proceed.I wish to know if there is a way to relieve a cellular reference such as A1 as well as B2 or maybe C3 for a number.What I want to do is compose a method that looks like A(1+2) to get A3.Case:

An ordinary formula might say

=A1+B2 / (B2+C3)

Even so, I need to write something similar to

=A1+B(1+1) / B(1+1)+C(1+2) to get the very same formula…=A1+B2 / (B2+C3)

Generally, I want youngster should be change the values belonging to the formula themselves, cells plus columns, prior to the calculations will be done.

Thanks ahead of time!!!

Hi,

You must use your =indirect function – like so:

=A1+INDIRECT(“B”&(1+1))/ (INDIRECT(“B”&(1+1))+ INDIRECT(“C”&(1+2)))

That equates that will

=A1+B2 / (B2+C3)

Anticipation this facilitates.

Andrew

=(A1+INDIRECT(“B”&F1)) / (INDIRECT(“B”&F1)+INDIRECT(“C”&F2))
where by F1 is B valuation and F2 is C worth.