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's fantastic! Thank you so much for your help!