Excel Nested Loop - Circular Reference

[Qshake]

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.

Regards,
Qshake

Eng-Tips Forums:Real Solutions for Real Problems Really Quick.

 

[MintJulep]

All of your if and then cases return a boolean 1 or 0.

You can't change the value of another cell with a formula.

 

[Qshake]

I've figured it out....just after posting. I'm too stuck in the old code languages where we have to assign the results to another varible.

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,
Qshake

Eng-Tips Forums:Real Solutions for Real Problems Really Quick.