rounding the answer of a formula

  • Thread starter Thread starter Peo Sjoblom
  • Start date Start date
I want to divide one number by another and round the answer up to the
nearest hundreth.
Ie, 38 inches divided by 12 equals 3.17.
Right now I can DISPLAY the 3.17 but when using that in a formula it's
calculating with 3.1667

Thanks in advance
Boze
 
One way:

=ROUNDUP(A5/12,2)

Boze said:
Thank you!

Instead of a number how would I write this if I wanted to reference a cell?
There will be a column of numbers and I'll want to divide each number by 12.
A5/12
A6/12
A7/12 etc

Thanks
Boze

one way:

=ROUNDUP(38/12,2)
Click to expand...
 
Thank you!

Instead of a number how would I write this if I wanted to reference a cell?
There will be a column of numbers and I'll want to divide each number by 12.
A5/12
A6/12
A7/12 etc

Thanks
Boze

one way:

=ROUNDUP(38/12,2)
 
=ROUNDUP(A5/12,2) entered in B5.

Double-click on B5 fill handle to copy down as far as you have numbers in A.


Gord Dibben MS Excel MVP
 
Thanks, I'll try that. I've never heard of or seen 'Ceiling' before. Very
cool

Thanks again
Boze


=CEILING(A2,0.01)

with the formula in A2
 
That works great. Is there a way that I can get zeros to show so there's
always 2 digits after the decimal point? 3.00 instead of 3 ?


"Gord Dibben" <gorddibbATshawDOTca> wrote in message
=ROUNDUP(A5/12,2) entered in B5.

Double-click on B5 fill handle to copy down as far as you have numbers in A.


Gord Dibben MS Excel MVP
 
Geez, I should've been able to figure that one out. Guess it was too
obvious!

Thanks again, Gord
Boze

"Gord Dibben" <gorddibbATshawDOTca> wrote in message
Format>Cells>Number>Number. Set to two decimal places.


Gord
 
Back
Top