| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
QP formulas not working in Excel
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(B1050.00001,B104-((B111-C111)/3),0))) D104=(IF(B105<0.00001,0,IF(B1050.00001,C104-((C111-D111)/2),0))) E104=(IF(B1050.00001,IF(E111B111,B104+(E111-B111)*(0.666666666666667),IF(E111C111,B104-(B111-E111)/3,IF(E111D111,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) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
QP formulas not working in Excel
On May 2, 2:34 pm, Westech wrote:
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(B1050.00001,B104-((B111-C111)/3),0))) D104=(IF(B105<0.00001,0,IF(B1050.00001,C104-((C111-D111)/2),0))) E104=(IF(B1050.00001,IF(E111B111,B104+(E111-B111)*(0.666666666666667),IF(E111C111,B104-(B111-E111)/3,IF(E111D111,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) B103 references itself. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
QP formulas not working in Excel
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. "Spiky" wrote: On May 2, 2:34 pm, Westech wrote: 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(B1050.00001,B104-((B111-C111)/3),0))) D104=(IF(B105<0.00001,0,IF(B1050.00001,C104-((C111-D111)/2),0))) E104=(IF(B1050.00001,IF(E111B111,B104+(E111-B111)*(0.666666666666667),IF(E111C111,B104-(B111-E111)/3,IF(E111D111,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) B103 references itself. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| My formulas in excel are suddenly not working. Help! | Excel Worksheet Functions | |||
| WHY DO FORMULAS STOP WORKING IN EXCEL | Excel Worksheet Functions | |||
| Formulas Not Working in Excel 2003 | Excel Discussion (Misc queries) | |||
| working with excel worksheets, formulas | New Users to Excel | |||
| formulas in excel are not working | Excel Worksheet Functions | |||
Linear Mode
