Hi there, I have a spreadsheet I’m working on for employees worked hours. Depending on values after decimal, I want to either round down or up. Example: If value after decimal is (between .01-.24,round to 0),(between .25-.49,round to .25),(between .50-.74, rounds to .50),(between .75-.90, rounds to .75), and (between .90-.99, rounds up to 1 or next whole number).
So 5.24=5.00
5.40=5.25
5.60=5.50
5.90=5.75
5.91=6.00
Thank you for any help.
So 5.24=5.00
5.40=5.25
5.60=5.50
5.90=5.75
5.91=6.00
Thank you for any help.