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)
Try
=CEILING(B12*B3, 1/12)
If you want to round that to 2 decimal places, use
=ROUND(CEILING(B12*B3, 1/12), 2)
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?