View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Joyce[_3_] Joyce[_3_] is offline
external usenet poster
 
Posts: 1
Default mortgage payment

i need to create a formula for calculating a mortgage payment with out using
the pmt option in excel. I have to be able to calculate both a interest only
payment and a payment including interest depending on the type of loan
selected. I cant use the pmt option because it shows as a - in my approval
cell and I cant have it show that way. please help