Consulting | Excel Examples

Feet and InchesTutorial

Conversion of Feet and Inches to Decimal Values

You can create these User Defined Functions: CFeet converts from decimal inches to feet, inches and fractions of inch. The second parameter of CFeet specifies the smallest fraction of inch for rounding. If omitted, fractions are rounded to 9999th's of an inch. CInches converts from feet, inches and fractions of inch to decimal inches.

 

 

[HRule Image]

Last modified: September 16, 2010