Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Equation and roundup in the formula bar
What would the eqauiton be if I want to divide 2 cells and round up or down
to the nearest 110th? Example D2/D3 rounded to the nearest 100th. Thanks, Rod |
#2
|
|||
|
|||
=round(a1/b1,-2)
or roundup(a1,b1,-2) or =rounddown(a1/b1,-2) "Rod" wrote in message ... What would the eqauiton be if I want to divide 2 cells and round up or down to the nearest 110th? Example D2/D3 rounded to the nearest 100th. Thanks, Rod |
#3
|
|||
|
|||
If it is 100th, wouldn't it be
=ROUND(A1/B1,2) etc. -- HTH Bob Phillips "N Harkawat" <nharkawat@hotmail_dot_com wrote in message ... =round(a1/b1,-2) or roundup(a1,b1,-2) or =rounddown(a1/b1,-2) "Rod" wrote in message ... What would the eqauiton be if I want to divide 2 cells and round up or down to the nearest 110th? Example D2/D3 rounded to the nearest 100th. Thanks, Rod |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|