Rounding Up or Down

[ToddM]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel How do I round up or down to the nearest $ .25 increment in a formula written in to express currency.

Thanks,
Todd

 

[Carl Witthoft]

Version: 2008
Operating System: Mac OS X 10.6 (Snow Leopard)
Processor: Intel

How do I round up or down to the nearest $ .25 increment in a formula written
in to express currency. <br><br>Thanks, <br>
Todd

Read
Help: ROUND()

If that's insufficient, then you'll have to convert from dollars to
quarters, round, and convert back.