View Single Post
  #1   Report Post  
mike
 
Posts: n/a
Default Having Trouble With Roundup

Cell F21 has a value of 908140. I want to divide this number by 27.4
and round the result up to the nearest 1000. I have put in a formula in
the cell I want the answer =Roundup(($F$21/27.4),3). The result I get
is 33144. This is the result of dividing the 908140 by 27.4. No
rounding is taking place. What am I doing wrong?
Thanks for any and all help.