View Single Post
  #2   Report Post  
N Harkawat
 
Posts: n/a
Default

=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