Substitute Circular Reference with Recursive Lambda function

[AEAA]

Hi all

I've been trying unsuccessfully to replace a circular reference with a recursive lambda function. Any help would be appreciated.

So I have a value in cell A1 let's say a Bank Loan Principal
And in cell A2 I have a formation fee of 2%*A1. Then I would like to have that A1 = Principal+Formation Fee. So it is a circular reference. As I understand I can create this iteration with Lambda in cell A1 to avoid activating iterative calculations. The help is greatly appreciated.

 

[StephenCrump]

Why over-complicate this?

Surely it's much easier to understand/check what's going on if you show:

	A	B
1	Loan	100,000
2	Fee	2%
3	Total borrowed	102,000
Sheet1

Cell Formulas
Range	Formula
B3	B3	=Loan*(1+Fee)

Named Ranges
Name	Refers To	Cells
Fee	=Sheet1!$B$2	B3
Loan	=Sheet1!$B$1	B3

 

[AEAA]

Why over-complicate this?

Surely it's much easier to understand/check what's going on if you show:

	A	B
1	Loan	100,000
2	Fee	2%
3	Total borrowed	102,000
Sheet1

Cell Formulas
Range	Formula
B3	B3	=Loan*(1+Fee)

Named Ranges
Name	Refers To	Cells
Fee	=Sheet1!$B$2	B3
Loan	=Sheet1!$B$1	B3

Sorry I don't know if I made my point clear on the first place.

The Bank Loan Principal will include loaning the money for the transaction fee, but the transaction fee depends on the bank loan, so its a circular reference. The higher the loan the higher the fee the higher the loan and so on, eventually they converge into one value.

 

[StephenCrump]

OK, in that case:

	A	B
1	Net amount to be borrowed	100,000
2	Fee (% total borrowed)	2%
3	Total borrowed	102,040.82
Sheet1

Cell Formulas
Range	Formula
B3	B3	=Loan/(1-Fee)

Named Ranges
Name	Refers To	Cells
Fee	=Sheet1!$B$2	B3
Loan	=Sheet1!$B$1	B3