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