Cost Per Page Countif formulea Closed

Question

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

venkat1926 · Answer

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),"")))

Cost Per Page Countif formulea

1 response

Similar discussions

Subscribe To Our Newsletter!