ExcelBanter - How do i convert years to months (formula)

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do i convert years to months (formula) (https://www.excelbanter.com/excel-worksheet-functions/31218-how-do-i-convert-years-months-formula.html)

SDPMIAMI

How do i convert years to months (formula)

Im trying to do a PMT funtion, but i have years instead of months. We have to
have a formula, no manually converting. Thanks Steve

Peo Sjoblom

We? Years as in decimal years, if so there is no 100% exact answer unless
you have something like

3.5 if so you can us 3.5*12

--
Regards,

Peo Sjoblom

(No private emails please)

"SDPMIAMI" wrote in message
...
Im trying to do a PMT funtion, but i have years instead of months. We have
to
have a formula, no manually converting. Thanks Steve

All times are GMT +1. The time now is 01:16 PM.