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

=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