Previous Topic Next Topic

Cost Per Page Countif formulea

Closed
RobDazey
Posts
1
Registration date
Wednesday July 15, 2009
Status
Member
Last seen
July 16, 2009
 - Jul 16, 2009 at 10:18 AM
 Rob - Jul 17, 2009 at 07:06 AM
Hello,
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.

Thanks in advance
Rob
Related:

1 reply

Answer 1 / 1
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
 805
Jul 16, 2009 at 09:56 PM
suppose the no of pages (120) is in A2
in B2 copy paste this formula (both lines if there are in two lines in your received message)

=IF(AND(A2>0,A2<=20),0.93*(A2-20),IF(AND(A2>20,A2<=100),0.93*20+0.83*(A2-100),IF(A2>100,0.93*20+0.83*80+0.66*(A2-100),"")))
0
Rob
Jul 17, 2009 at 07:06 AM
Thank you for the trouble - it was just what I needed - ROB
0