Round up to the next 200

  • Thread starter Thread starter Pete in OZ
  • Start date Start date
P

Pete in OZ

I need to know how to round up to the next 200.

i.e. If I have a fugure of 139540, it needs to
automatically round up to 139600.

More examples:
123450 = 123600
100680 = 100800
etc etc

I have been going nuts on this and my head is going to
explode soon. Please help this stupid Australian.

Thanks
..
 
Try

=CEILING(A1,200)

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Thanks mate...youre a champion!!!!!!!!!!!!!!!
-----Original Message-----
Try

=CEILING(A1,200)

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)






.
Click to expand...
 
Hi,


=A1+(A1/200<>0)*(200-MOD(A1,200))


--
Regards,
Soo Cheon Jheong
_ _
^¢¯^
--
 
=A1+(A1/200<>0)*(200-MOD(A1,200)) --- Error

another way:

=A1+(MOD(A1,200)>0)*(200-MOD(A1,200))


--
Regards,
Soo Cheon Jheong
_ _
^¢¯^
--
 
Soo Cheon Jheong said:
=A1+(A1/200<>0)*(200-MOD(A1,200)) --- Error

another way:

=A1+(MOD(A1,200)>0)*(200-MOD(A1,200))
Click to expand...

That looks a bit too complicated for me!


=CEILING(A1,200)


HTH,

Alan.
 
Back
Top