MOD formula not working correctly

[Tascja]

Hello,
I'm having an issue with the MOD formula. I need to convert a height in centimeters to feet and inches, with the Ft and In reported as separate fields. I use the following steps:

Field 1: Ht(in): [Ht(cm)]/2.54 - gives me height in inches
Field 2: HeightFT: Int([Ht(in)]/12) - gives me height in feet rounded to a whole integer
Field 3: HeightIN: [Ht(in)] Mod 12 - gives me the remainder of inches from height in feet

This works 99% of the time. I found it doesn't work for values that are close to a whole value in feet (ie. 3 ft 11.8 in, 4 ft 11.9 in).

For the following values the above steps don't work:


152 cm : this is reported as Field 2: 4 Ft and Field 3: 0 In (Because the remainder is 11.8 it gets rounded to 12 and then there is no longer any remainder from 12)
121 cm : this is reported as Field 2: 3 Ft and Field 3: 0 In (Because the remainder is 11.6 it gets rounded to 12 and then there is no longer any remainder from 12)

How do I stop Field 3 from rounding the remainder? Or does anyone have any other suggestions on how I can get the Height from Centimeters to Feet and Inches accurately.
Thanks in advance for any help!!

[June7]

If you want to eliminate use of MOD:

Feet: Int([Ht(cm)]/2.54/12)

Inches: ([Ht(cm)]/2.54/12 - Int([Ht(in)]*2.54/12)) * 12

[Tascja]

Thanks for your suggestion! I'll try it out and see if it eliminates the issue.