Thread: How do I round-off to the nearest dollar in Excel 2000?
View Single Post
  #4   Report Post  
Jerry W. Lewis
 
Posts: n/a
Default
=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)

Reply With QuoteReply With Quote