Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert equation to formula | Excel Discussion (Misc queries) | |||
Converting number of days to years and months | Excel Worksheet Functions | |||
how to calculate years, months by using one formula | Charts and Charting in Excel | |||
how does one convert text to a formula "average(A:A)" to =average( | Excel Worksheet Functions | |||
Need number of months or weeks passed from formula | Excel Worksheet Functions |