Rounding, linked cells...pls HELP!!!!!!

[Cristine Huma]

Does anyone know if this is possible. My cell is hyperlinked to another sheet (this cell is not rounded) but I need the number that is pulled in to be rounded to the nearest hundred. Your help is appreciated.

 

[klb]

Why are you using a hyperlink which will take you to that cell not return the value of it?
Why not use the round formula and reference that cell directly?

 

[Cristine Huma]

the cell does return the value and is also hyperlinked. Sorry I didn't state that, but your response trigered me to use the ceiling formula along with my reference, thanks.
Now, my next dilema is ......
I need it to round as follows:
if value = $499, then cell s/b 0
if value = $501, then cell s/b $1000

I will play around with it for a while, thx again