Thread: Rate function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Professor Henn Professor Henn is offline
external usenet poster
 
Posts: 1
Default Rate function

Getting #Num1 error for the rate function for 200000-PV -41067-PMT, and
20-years the rate is 20% . Excel is not calculating the rate. I can use my
financial calculator and get an answer.

Note: This does work for 15 years. I tried experimenting with the
iterations under excel options under calculation.