How do I round-off to the nearest dollar in Excel 2000?

[Fred Smith]

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

 

[Bryan Hessey]

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

 

[Jerry W. Lewis]

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

Jerry