I'll buy someone a beer ($5) if they can solve my excel rounding problem.
I'm at a loss. I work for a company that provides case management, and we bill medicaid for services provided. I've been given the duty of working out the billing spreadsheet in Excel. The trouble I'm running into is converting minutes into billable units. According to Medicaid, 1-7.5 minutes is half a unit, and 7.51-15 minutes is considered a unit. So if a case manager works with a client for 4 minutes, they should be able to bill for half a unit. If they work with a client for 8 minutes, they can bill for a unit. I can't get excel to round the way I want it to. Right now I'm working with a formula like this:
=MROUND(E8/15, .05)
but I can't get it to round properly to whole units and half units. I need excel to round up to the whole number (unit) when the minutes are above 7, and down to half (.5) when it's at 7 or below.
Any help or ideas? I can pay for your beer via paypal or a personal check.
-joshua
Bookmarks