How to convert numeric number value to numeric years months
i.e.
numbers year & month
13 1.01
15 1.03
24 2
37 3.01
any formula / macro coding
How to convert numeric number value to numeric years months
i.e.
numbers year & month
13 1.01
15 1.03
24 2
37 3.01
any formula / macro coding
=int(a1/12)+mod(a1, 12)/100
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
Another way:
a b c 1 13 1.01b1: =dollarfr(a1/12,12) 2 15 1.03 3 24 2.00 4 37 3.01
Entia non sunt multiplicanda sine necessitate
thanks to all
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks