Use a format with zero decimal places, or use =round(a1,0)

--
Regards,
Fred
Please reply to newsgroup, not e-mail


"The Blind One" <The Blind wrote in message
...

To the nearest dollar,
=roundup(a1,0)


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=385475

=ROUNDUP(4.01,0)
will return 5, even though 4 is the nearest dollar. I think you meant
ROUND.

Jerry

Bryan Hessey wrote:

To the nearest dollar,
=roundup(a1,0)