LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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





 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need help writing a formula lakwriter Excel Discussion (Misc queries) 3 November 2nd 09 03:04 PM
writing an IF/AND formula Jill_ Excel Worksheet Functions 1 October 15th 09 06:29 PM
writing a formula chrissy Excel Worksheet Functions 4 November 3rd 08 08:24 PM
Writing a formula julescc Excel Worksheet Functions 6 March 3rd 05 01:45 AM
Formula Writing Josh[_6_] Excel Programming 2 September 18th 03 06:42 PM


All times are GMT +1. The time now is 06:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"