Round up to the next 200

[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
..

 

[Peo Sjoblom]

Try

=CEILING(A1,200)

--
Regards,

Peo Sjoblom

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

 

[Pete]

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)






.

 

[Soo Cheon Jheong]

Hi,


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


--
Regards,
Soo Cheon Jheong
_ _
^¢¯^
--

 

[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
_ _
^¢¯^
--

 

[Alan]

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

another way:

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

That looks a bit too complicated for me!


=CEILING(A1,200)


HTH,

Alan.