G Guest Feb 16, 2007 #1 if i have a value such as 1.9878 and want to show it to the nearest feet and inches how would i do it?
if i have a value such as 1.9878 and want to show it to the nearest feet and inches how would i do it?
M macropod Feb 16, 2007 #2 Hi, Depends on what you're trying to convert. Nautical miles, yards, metres, leagues? I suspect metres, in which case you could use: =INT(A1/0.3048)&"ft "&ROUND((A1/0.3048-INT(A1/0.3048))*12,0)&"in" Cheers -- macropod [MVP - Microsoft Word] | if i have a value such as 1.9878 and want to show it to the nearest feet and | inches how would i do it? | |
Hi, Depends on what you're trying to convert. Nautical miles, yards, metres, leagues? I suspect metres, in which case you could use: =INT(A1/0.3048)&"ft "&ROUND((A1/0.3048-INT(A1/0.3048))*12,0)&"in" Cheers -- macropod [MVP - Microsoft Word] | if i have a value such as 1.9878 and want to show it to the nearest feet and | inches how would i do it? | |
B Bernard Liengme Feb 16, 2007 #3 But if 1.9878 is in feet, then format the sell with custom format # ??/12 to see 2 And 15.56 shows as 15 7/12 If 1.9878 is metres and is in A1 then =A1/0.038 with the same custom format show 52 4/12 In all cases, the values are numeric and you can do math on them. best wishes
But if 1.9878 is in feet, then format the sell with custom format # ??/12 to see 2 And 15.56 shows as 15 7/12 If 1.9878 is metres and is in A1 then =A1/0.038 with the same custom format show 52 4/12 In all cases, the values are numeric and you can do math on them. best wishes
G Guest Feb 17, 2007 #4 Hello macropod, in some circumstances, e.g. when A1 = 1.82 the result of your suggested formula will be "5ft 12in". To always get "6ft 0in" try =INT(ROUND(A1/0.0254,0)/12)&"ft "&MOD(ROUND(A1/0.0254,0),12)&"in"
Hello macropod, in some circumstances, e.g. when A1 = 1.82 the result of your suggested formula will be "5ft 12in". To always get "6ft 0in" try =INT(ROUND(A1/0.0254,0)/12)&"ft "&MOD(ROUND(A1/0.0254,0),12)&"in"
