convert Inches to the nearest foot

  • Thread starter Thread starter Mario454
  • Start date Start date
hi
with inches in column A, you could use a fomula like this...
=A2*(1/12)
then format the formula cell to zero decimals for roundoff.
or
=round(A2*(1/12),0) and not have to format the cell.
if you have the analysis tool pack, you could use then use the DOLLARDE and
DOLLARFR functions.
see this site on how to use them
http://www.cpearson.com/excel/fractional.htm

regards
FSt1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert Ft'-In Fr" (5'-6 3/4") to Ft.dec (5.56) 6
Round to nearest foot (12 inches) 2
Roof Angle 6
Excel How To Convert Decimal To Inches 2
convert to feet and inches 3
Conversions of Decimal Feet to Decimal Inches - Formula?? 0
Formula converts a value to Feet Inches and fractions of an inch 1
Data entry & Formula in same cell 4

Back
Top