Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF & VLOOKUP FORMULA | Excel Worksheet Functions | |||
Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Help with macro formula and variable | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |