Forum Discussion
Solved
ROUNDING FORMULA TO NEAREST INCH IN DECIMAL FORM
Good afternoon y'all, I am in need of assistance with Excel. I don't quite know how to search for solutions to my problem, so I'm hoping that by starting this posting I can get some help from the pr...
Try
=CEILING(B12*B3, 1/12)
If you want to round that to 2 decimal places, use
=ROUND(CEILING(B12*B3, 1/12), 2)
There's one more thing I'd like to ask about. You're formula =ROUND(CEILING(B12*B3, 1/12), 2) works perfectly with most of the calculations except for when the answer should be #.66. The program wants to keep saying that it's .67 instead. Is there a way to correct it and make it say .66 instead?
LORDPHILLIP if what you mean is you want to round up to nearest inch fraction but then truncate (i.e. round down) after 2 digits then just use ROUNDDOWN
=ROUNDDOWN(CEILING(B12*B3, 1/12), 2)
here is a table for comparisons
| inches | decimal | rounded | roundDown |
| 1 | 0.083333 | 0.08 | 0.08 |
| 2 | 0.166667 | 0.17 | 0.16 |
| 3 | 0.25 | 0.25 | 0.25 |
| 4 | 0.333333 | 0.33 | 0.33 |
| 5 | 0.416667 | 0.42 | 0.41 |
| 6 | 0.5 | 0.5 | 0.5 |
| 7 | 0.583333 | 0.58 | 0.58 |
| 8 | 0.666667 | 0.67 | 0.66 |
| 9 | 0.75 | 0.75 | 0.75 |
| 10 | 0.833333 | 0.83 | 0.83 |
| 11 | 0.916667 | 0.92 | 0.91 |
| 12 | 1 | 1 | 1 |