How do I change formula to get loan period in months, not years?
N Niek Otten Mar 9, 2006 #2 Multiply the number of periods by 12 and change the rate. This last one depends on how it is calculated: simplest is divide by 12, but you may need the EFECT or NOMINAL function to compute the rate. Depends on your specs. See HELP for the functions.
Multiply the number of periods by 12 and change the rate. This last one depends on how it is calculated: simplest is divide by 12, but you may need the EFECT or NOMINAL function to compute the rate. Depends on your specs. See HELP for the functions.
