Round to nearest foot (12 inches)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to enter a number in a cell and write a formula so that it
automatically rounds it up to the nearest 12" (foot).
 
On Wed, 6 Sep 2006 18:21:01 -0700, Round to nearest foot <Round to nearest
I would like to enter a number in a cell and write a formula so that it
automatically rounds it up to the nearest 12" (foot).
Click to expand...

What is the nature of the number?

If the number is a value in inches, then:

=CEILING(A1,12)


--ron
 

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 Inches to the nearest foot 2
advice on rounding or ceilng a 24 hour time value 3
rounding up to nearest specified whole number 1
Formula converts a value to Feet Inches and fractions of an inch 1
Average rounded to nearest 0.50 4
round up to nearest 50p 1
Data entry & Formula in same cell 4
Round time up to nearest :15 2

Back
Top