Reference of Indirect Formula

**EStegenburgs** · 03-21-2010, 06:09 AM

Hi,
I have searched a lot about this but I can't find a good solution to this problem.
Here it is described - http://www.mrexcel.com/archive/Formulas/14110.html.
Thanks.

**teylyn** · 03-21-2010, 06:17 AM

Hello Estegenburgs,

if you have a question, could you please spell it out instead of linking to another site? We don't have a clue whether the solutions provided on the other site meet your requirements, or if any (and if so, which) elements are still missing.

So, what is it that you want to achieve? What is your input? What is your expected output? What is the logic that would lead from input to output?

All in one post in this forum, preferrably.

Thanks.

**zbor** · 03-21-2010, 06:20 AM

Like this?

**EStegenburgs** · 03-21-2010, 07:14 AM

The situation is like that (further look in attachment) I need to calculate (delta)Ri and (delta)Ru. I want that I could only write data and formula after which excel must calculate (delta)Ri and (delta)Ru what is depending on this given formula (I have written a sample of this formula in excel).
Is it possible?

**EStegenburgs** · 03-22-2010, 06:16 PM

More clear question from my side would be that if I can only write this formula...
R=U/I
and from it excel would make these formulas...
(delta)Ru=(U+(delta)U)/I-U/I
and
(delta)Ri=U/(I+(delta)I)-U/I

As you see (delta)R formulas depends on the basic formula R=U/I.
I want that I could only write the basic formula and excel would make these (delta) formulas itself.