Thread
:
round up a 1999 + 1999 to the nerest 100 = 2000 + 2000
View Single Post
#
1
Fred Smith
Posts: n/a
=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
Reply With Quote