MOD function "feature"

[quisizyx]

Greets- Ran into strange bogosity w/MOD function where MOD (N,12) where 12 divides evenly into N w/no remainder gives a result of 12. ?? Should B 0. Any1 run into this B4? On a Samsung Tab Pro 12.3 inch tablet w/Android running office suite app Polarus. Recent Android update but MOD function results the same B4 & after update. WTF?

[Tony Valko]

MOD (N,12) where 12 divides evenly into N w/no remainder gives a result of 12.

Tell us what N is.

[sandy666]

Try to read here: MOD()

[AliGW]

Quisizyx - why did you report your post?

[MrShorty]

To expand on Tony Valko's comment, I suspect that n is not an exact multiple of 12, but something slightly less than. For example, I put 11.999999999999 into a cell (it displayed as 12) and entered =MOD(A1,12) and the result was 12. Format to show all 15 digits, and the actual result is 11.999999999999, which will frequently display as 12. Because Excel's calculations are all in double precision, if N is the result of some other calculation, it would be easy for N to be 12*k-1ppt. Since Excel's MOD() function does not adjust N at all (some programming languages like VBA will round N to the nearest integer before performing the mod operation), it is easy for round off error to make something that we think should be 0 come out as 12.

[quisizyx]

Greets- Ok, this is interesting. I originally posted on MrExcel forum. Had trouble posting so decided to try this forum. To my surprise I find my original post here w/responses I have not seen. Plus my MrExcel login works here. The value of N is listed in the MrExcel forum along w/several tests trying to find the trigger for the floating point issue Excel has. The MOD(ROUND(N,2),12) seems to work for the remaining inches column after the feet are derived from the total inches. N = 33012. Should give a result in feet of 2751 but gives 2750. Will study responses here then continue later. Now to see if this forum gives the seem issue on posting I was having on MrExcel.