View Single Post
  #1   Report Post  
Fred Smith
 
Posts: n/a
Default

=roundup(b1+b2,-2)

--
Regards,
Fred
Please reply to newsgroup, not e-mail


"Keith Lumley" <Keith wrote in message
...
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