Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm trying to complete an Excel 2000 model and I need some help with the
basic algebra. Can someone please rewrite this for me to solve for P1? A = ( P1+ P2 ) / ( 1+ ( R1 * ( D1 + D2 ) ) I know: A = 99,200.881785616 (approx.) P2 = 100,000.00 R1= 0.10 / 360 = 0.000277777778 (approx.) D1= 31 D2= 29 and we know P1 will equal: 854.229815376 (approx.) Additionally, can this be rewritten to solve for P2? A = P2 / ( 1 + ( R1 * D2 ) ) Which, given the above value, P2 will again equal 100,000.00 Thanks a lot in advance. This would be a big help. I hate the idea of cracking some text books that I've not looked at in 30 years! Karl |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need help writing a formula | Excel Discussion (Misc queries) | |||
writing an IF/AND formula | Excel Worksheet Functions | |||
writing a formula | Excel Worksheet Functions | |||
Writing a formula | Excel Worksheet Functions | |||
Formula Writing | Excel Programming |