View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Karl Karl is offline
external usenet poster
 
Posts: 2
Default Help needed with writing a formula

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