beenay
New Member
- Joined
- Oct 9, 2002
- Messages
- 10
I need to round a number to it's nearest multiple of 5. Example: 15 would equal 15, 16 would equal 15, 17 would equal 15, 18 would equal 20, 19 would equal 20, and 20 would equal 20.
CEILING and FLOOR don't work because they either always round up, or always round down.
This message was edited by beenay on 2002-10-11 12:14
This message was edited by beenay on 2002-10-11 12:20
This message was edited by beenay on 2002-10-11 12:27
CEILING and FLOOR don't work because they either always round up, or always round down.
This message was edited by beenay on 2002-10-11 12:14
This message was edited by beenay on 2002-10-11 12:20
This message was edited by beenay on 2002-10-11 12:27