2007/6/9, Dave Barton <[EMAIL PROTECTED]>:
-------- Original Message --------
From: James Lockie <[EMAIL PROTECTED]>
Date: Sat 09 Jun 2007 14:43:48 EST
> I have a spreadsheet that has a number (25) that is the number of
> months. I want to display the number of years and months, like 2.1
> (24 months=2 years and 1 month remaining).
Would =INT(A1/12)+(MOD(A1;12)/10) work for you?
Dave
That only works if your standard decimal character is set to ".". If it's
not, you can set it to "." for that cell or range of cells if you like. If
you don't want to do that, try:
=INT(A1/12)&"."&(MOD(A1;12))
This does the same thing as "=CONCATENATE((ROUNDDOWN(25/12));".";MOD(25;12))",
suggested by Ahromi, but is a bit shorter to type... (the "&" characters is
instead of CONCATENATE).
The difference between INT and ROUNDDOWN is that the INT function rounds
towards -∞ ("minus eternity", in case you can't see unicode characters
properly in your email) while ROUNDDOWN rounds towards 0 (zero). That means
that INT(-3.6) = -4 and ROUNDDOWN(-3.6) = -3.
Johnny Andersson
