I have a number as a decimal in feet and I want that number in feet and inches with the inches in a fraction. I have a formula for getting the number into a 16th fraction
=IF(MOD(INT(16*(+B4-INT(B4)+0.0312)),16)=0,TEXT(B4,"#"),IF(MOD(INT(16*(+B4-INT(B4)+0.0312)),8)=0,TEXT(B4,"# 0/2"),IF(MOD(INT(16*(+B4-INT(B4)+0.0312)),4)=0,TEXT(B4,"# 0/4"),IF(MOD(INT(16*(+B4-INT(B4)+0.0312)),2)=0,TEXT(B4,"# 0/8"),TEXT(B4,"# 0/16")))))
If I enter the number, say 325.28 into A1, I want 325 to show up in A2 and then 3 3/8 to show up in A3. The formula above will take 3.36 (which is .28*12 and display the 3 3/8), I just need to seperate the decimal from the larger number, multiply it by 12 and apply the formula above all in one cell.
=IF(MOD(INT(16*(+B4-INT(B4)+0.0312)),16)=0,TEXT(B4,"#"),IF(MOD(INT(16*(+B4-INT(B4)+0.0312)),8)=0,TEXT(B4,"# 0/2"),IF(MOD(INT(16*(+B4-INT(B4)+0.0312)),4)=0,TEXT(B4,"# 0/4"),IF(MOD(INT(16*(+B4-INT(B4)+0.0312)),2)=0,TEXT(B4,"# 0/8"),TEXT(B4,"# 0/16")))))
If I enter the number, say 325.28 into A1, I want 325 to show up in A2 and then 3 3/8 to show up in A3. The formula above will take 3.36 (which is .28*12 and display the 3 3/8), I just need to seperate the decimal from the larger number, multiply it by 12 and apply the formula above all in one cell.