QP formulas not working in Excel

W

Westech

Can't get the formulas I used in Quatro Pro to calculate in Excel: circular
reference that wasn't abated by changing iterations. Having a senior moment
and can't identify what I'm missing. Formulas shown below. Be grateful for
any input. Thanks.
B93=n1
E97= n2
D98=n3
B102=(B111-D98)
C102=(C111-D98)
D102=(D111-D98)
E102=(E111-D98)
B103=(IF(ABS(D110-D109)>0.000002,B103+(D110-D109)/2,B103))
C103=((C102/C111)*100)
D103=((D102/D111)*100)
E103=((E102/E111)*100)
B104=((B111-E97)*B105/100)
C104=(IF(B105<0.00001,0,IF(B105>0.00001,B104-((B111-C111)/3),0)))
D104=(IF(B105<0.00001,0,IF(B105>0.00001,C104-((C111-D111)/2),0)))
E104=(IF(B105>0.00001,IF(E111>B111,B104+(E111-B111)*(0.666666666666667),IF(E111>C111,B104-(B111-E111)/3,IF(E111>D111,C104-(C111-E111)/2,D104-(D111-E111)/2))),0))
B105=10
C105=(C104/(C111-E97)*100)
D105=(D104/(D111-E97)*100)
E105=(E104/(E111-E97)*100)
B106=((D98-D82)*B107/100)
C106=(B106)
D106=(B106)
E106=(B106)
B107=23
C107=(B107)
D107=(B107)
E107=(B107)
B108=(SUM(B102-B104-B106))
C108=(SUM(C102-C104-C106))
D108=(SUM(D102-D104-D106))
E108=(SUM(E102-E104-E106))
B109=(B108/B111*100)
C109=(C108/C111*100)
D109=(D108/D111*100)
E109=(E108/E111*100)
D110=12
B111=(D98/(1-B103/100))
C111=(B111-((B111)*C101/100))
D111=(C111-((B111)*D101/100))
E111=n4
B112=(B93)
C112=(B93)
D112=(B93)
E112=(B93)
B113=(B111+B112)
C113=(C111+C112)
D113=(D111+D112)
 
S

Spiky

Can't get the formulas I used in Quatro Pro to calculate in Excel: circular
reference that wasn't abated by changing iterations. Having a senior moment
and can't identify what I'm missing. Formulas shown below. Be grateful for
any input. Thanks.
B93=n1
E97= n2
D98=n3
B102=(B111-D98)
C102=(C111-D98)
D102=(D111-D98)
E102=(E111-D98)
B103=(IF(ABS(D110-D109)>0.000002,B103+(D110-D109)/2,B103))
C103=((C102/C111)*100)
D103=((D102/D111)*100)
E103=((E102/E111)*100)
B104=((B111-E97)*B105/100)
C104=(IF(B105<0.00001,0,IF(B105>0.00001,B104-((B111-C111)/3),0)))
D104=(IF(B105<0.00001,0,IF(B105>0.00001,C104-((C111-D111)/2),0)))
E104=(IF(B105>0.00001,IF(E111>B111,B104+(E111-B111)*(0.666666666666667),IF(E111>C111,B104-(B111-E111)/3,IF(E111>D111,C104-(C111-E111)/2,D104-(D111-E111)/2))),0))
B105=10
C105=(C104/(C111-E97)*100)
D105=(D104/(D111-E97)*100)
E105=(E104/(E111-E97)*100)
B106=((D98-D82)*B107/100)
C106=(B106)
D106=(B106)
E106=(B106)
B107=23
C107=(B107)
D107=(B107)
E107=(B107)
B108=(SUM(B102-B104-B106))
C108=(SUM(C102-C104-C106))
D108=(SUM(D102-D104-D106))
E108=(SUM(E102-E104-E106))
B109=(B108/B111*100)
C109=(C108/C111*100)
D109=(D108/D111*100)
E109=(E108/E111*100)
D110=12
B111=(D98/(1-B103/100))
C111=(B111-((B111)*C101/100))
D111=(C111-((B111)*D101/100))
E111=n4
B112=(B93)
C112=(B93)
D112=(B93)
E112=(B93)
B113=(B111+B112)
C113=(C111+C112)
D113=(D111+D112)
Click to expand...

B103 references itself.
 
W

Westech

In QP the circular reference eventually calculates to a number- can't get the
same results in Excel even though I changed the number of iterations.
Thanks, though.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If + And .... 5

Top