Excel Nested Loop - Circular Reference
Excel Nested Loop - Circular Reference
(OP)
Hello all.
I'd like for another set of eyes to see this if statement to see where a circular reference has occured (or not) and or point a trouble spot as to why it doesn't return the expected value.
=IF(M34>=0,(IF((K34*M34+G34)>=$N$7, G35=$N$7,G35=K34*M34+G34)),(IF(ABS(K34*M34+G34)>=$N$7, G35=-$N$7, G35=K34*M34+G34)))
The values of the cells are:
M34 = -0.02124
K34 = 10
G34 = 0
N7 = 0.303
for this case I believe that G35 should be -0.2124 but so far excel arrives at 0 and some hint a circular reference.
Any help would be greatly appreciated.
I'd like for another set of eyes to see this if statement to see where a circular reference has occured (or not) and or point a trouble spot as to why it doesn't return the expected value.
=IF(M34>=0,(IF((K34*M34+G34)>=$N$7, G35=$N$7,G35=K34*M34+G34)),(IF(ABS(K34*M34+G34)>=$N$7, G35=-$N$7, G35=K34*M34+G34)))
The values of the cells are:
M34 = -0.02124
K34 = 10
G34 = 0
N7 = 0.303
for this case I believe that G35 should be -0.2124 but so far excel arrives at 0 and some hint a circular reference.
Any help would be greatly appreciated.
Regards,
Qshake![[pipe] pipe](https://www.tipmaster.com/images/pipe.gif)
Eng-Tips Forums:Real Solutions for Real Problems Really Quick.





RE: Excel Nested Loop - Circular Reference
You can't change the value of another cell with a formula.
RE: Excel Nested Loop - Circular Reference
See where the results of the if state are I am asking it to set G35 equal to that computation rather than just leaving the computation!
Thanks for your help. This is quite effective from Eng-tips perspective - I post and then I solve. But from my perspective it's a pain and I find that I should have hit my head against the wall harder!!
Regards,
![[pipe] pipe](https://www.tipmaster.com/images/pipe.gif)
Qshake
Eng-Tips Forums:Real Solutions for Real Problems Really Quick.