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

1 reply

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
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
Thank you for the trouble - it was just what I needed - ROB
0