Posts1Registration dateWednesday July 15, 2009StatusMemberLast seenJuly 16, 2009
Jul 16, 2009 at 10:18 AM
Jul 17, 2009 at 07:06 AM
My hospital in South Georgia - US - chages .97 cents per medical record page from 1 -20
.83 cents per medical record over 21 pages to 100 pages
.66 cents per medical record page for anything over 101+
What we are looking for is an formulea for placing one number and giving the total cost to the patient.
If the total pages was 120 then I would want to total that cost .97 cents x 20 pages plus (+) .83 cents for the next 80 pages and .66 for the remaining pages (20) and get one cost.
If this is not possible with an countif formulea, would you steer me in the right direction.