For some of you Gurus of Programming this is a wiz... for me it's just a pain.

What I would like is code or help:

Project:

I am trying to enter a value in a cell (in excel) for example in Cell (C2)
then is cel (C6) I want to evaluate the Value and round it to the next hundred
if the value is 50514.00 I need to round it up to 50600 even if the value is 50500.01
I need it rounded up to 50600.

I have most of the code working except the part where it writes to the cell and also I want it to be
auto-calculating.

If anybody got any Ideas or can write it for me that will be great

Thanks

Pete