M
MSCom
Neuer Benutzer
Threadstarter
- Dabei seit
- 20.09.2016
- Beiträge
- 1
Dear all,
I do have a problem in finding a way to express a variable combination of formulas for the following task:
An investment in year x is repayed in year x + n in which n represents "30" (but should be variable)
When I use the formula "=-INDIRECT("R(-3)C(-30)";FALSE) then it works. But I like to make the reference to a cell in the spreadsheet "assumptions"
I tried to use ADDRESS(12;3;;;ASSUMPTIONS!) instead 30 but it does not work.
=-INDIRECT("R(-3)C(-ADDRESS(12;3;;;ASSUMPTIONS!))";FALSE)
Can someone help me please to find a solution for my problem?
thanks
I do have a problem in finding a way to express a variable combination of formulas for the following task:
An investment in year x is repayed in year x + n in which n represents "30" (but should be variable)
When I use the formula "=-INDIRECT("R(-3)C(-30)";FALSE) then it works. But I like to make the reference to a cell in the spreadsheet "assumptions"
I tried to use ADDRESS(12;3;;;ASSUMPTIONS!) instead 30 but it does not work.
=-INDIRECT("R(-3)C(-ADDRESS(12;3;;;ASSUMPTIONS!))";FALSE)
Can someone help me please to find a solution for my problem?
thanks
