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 professionals.
I am trying to have certain cells round my calculations up to the nearest inch in decimal form. So far I have been successful with making these cells calculate and round to 2 decimal places, but I need for them to round again to the nearest inch in decimal form (i.e. .08, .16, .25, .33, .41, .5, .58, .66, .75, .88, .92).
Currently the cells in question have the following formula =ROUNDUP(B12*B3,2). If the formula creates an answer like 341.18, I then want the program to make it round up to the nearest inch which would be 341.25.
Is there a way to make this happen, or am I asking too much of the program?
Any and all assistance is greatly appreciated.
Try
=CEILING(B12*B3, 1/12)
If you want to round that to 2 decimal places, use
=ROUND(CEILING(B12*B3, 1/12), 2)
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?
8 inches = 2/3 feet = 0.66666666... feet.
Rounded to 2 decimal places. this becomes 0.67, not 0.66
But if you really want 0.66. you could use
=ROUNDDOWN(CEILING(B12*B3, 1/12), 2)
- That's fantastic! Thank you so much for your help!
- That got me closer thank you. Here's what it just did. I changed the value of one of the cells and the answer it gave me this time is 584.9167. That's much closer than before, but I still need it to round it so that it says 584.92. Any thoughts?
