View Single Post
  #1   Report Post  
Keith Lumley
 
Posts: n/a
Default round up a 1999 + 1999 to the nerest 100 = 2000 + 2000

i want to round up a cell that has a fomular in it B1+B2 b1 is 1999 and b2 is
1999 the answer is 3998 but i want 4000
Thanks Keith