formula help
Hello.
If I have a figure such as 4.6666667, that I would like expressed in Years and Months, to the nearest month, what formula would I use to do this? Is it possible in Excel? Cheers John |
Well, not knowing exactly how you want the results formatted, here's one
approach: If the value is in cell A1 then, put this formula in any other cell: =ROUNDDOWN(A1,0)&" years, "&ROUND(MOD(A1,1)*12,0)&" Months" In your example, 4.66666 would display as "4 years, 8 months" Does that help? Regards, Ron "John" wrote: Hello. If I have a figure such as 4.6666667, that I would like expressed in Years and Months, to the nearest month, what formula would I use to do this? Is it possible in Excel? Cheers John |
All times are GMT +1. The time now is 09:43 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com