Qshake
Structural
- Jul 12, 2000
- 2,672
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
![[pipe] [pipe] [pipe]](/data/assets/smilies/pipe.gif)
Eng-Tips Forums:Real Solutions for Real Problems Really Quick.
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] [pipe]](/data/assets/smilies/pipe.gif)
Eng-Tips Forums:Real Solutions for Real Problems Really Quick.