Hi,
In another topic someone asked the amount of char before/after a decimal point
Example: [D14]=123456.1234 should give 6 before and 4 after
=LEN(INT(D14)) which works fine
=LEN(MOD(D14;1)-2) gives 17
This is because MOD(D14;1) = 0,123999999999999
Is it me, or is it MOD() ?
Ricardo
Looking for great solutions but hate waiting?
Seach this Forum through Google
www.Google.com (e.g. +multiple +IF site:excelforum.com/excel-general/ )
www.Google.com (e.g. +fill +combobox site:excelforum.com/excel-programming/ )
Ave,
Ricardo
This is down to they way excel stores numbers and the conversion between binary and decimal. There is not an easy answer
http://www.cpearson.com/excel/rounding.htm
explains the issue in more detail
Regards
Dav
Thx Dav for sending the link,
Figured there was no easy way out.
If you have the formula
=LEN(INT(D14))
in cell E14 for the number of digits before the decimal place then try this formula for the number of digits after
=MAX(0;LEN(D14)-E14-1)
Daddylonglegs,
I've used a similar function using the IF() for the (-1) caused by the comma. The Max is certainly more elegant. Great.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks