Forum Discussion
Solved
Removing decimals in a MOD formula
I am trying to create a formula which returns the average length of time in years and months from a data set. In column Z of my dataset I have lengths of time in months. In a new cell on a sep...
LL19911695 Like this perhaps?
=INT(B6/12) & " years and " & TEXT(MOD(B6,12),"0") & " months"
Alternatively:
=INT(B6/12) & " years and " & ROUND(MOD(B6,12),0) & " months"
LL19911695 Like this perhaps?
=INT(B6/12) & " years and " & TEXT(MOD(B6,12),"0") & " months"
Alternatively:
=INT(B6/12) & " years and " & ROUND(MOD(B6,12),0) & " months"
- That worked, thank you 🙂
LL19911695 Obviously, you can also wrap the MOD function in INT, similar to the year portion. Though, that would result in 9.
