View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Huskerpaulie Huskerpaulie is offline
external usenet poster
 
Posts: 1
Default PPMT function replacement

I'm trying to use Excel on my Palm Centro to determine the breakdown between
interest and principal for monthly mortgage payments, but the built-in
software does not allow PPMT, IPMT, and IF statements to be used. I am
allowed to use functions such as FV, IRR, NPER, NPV, PMT, PV, and RATE.

What function/formula or combination of function/formulas could I use to
determine the same information that the PPMT function provides?

Thanks for your help.
-Paul