>I need to be able to round a dollar amount to the nearest $5.00 programmatically.
>
>for example($21.85 -> $20.00, $23.00 -> $25.00)
You can try.
? ROUND($21.85/5,0) * 5
? ROUND($23.00/5,0) * 5
Charles
"The code knows no master." - Chuck Mautz
"Everybody is ignorant, only on different subjects." - Will Rogers