If function

[Artemio]

Hi there,

Could you please help me, how to formulate using IF FORMULA below details just to make it easier on me.
Thanking you in advance & I've fully appreciates your advance aid.

	a	b	c	d	e	f	g	Total
Months	January	February	March	April	May	June	July
Invoice/ Procedures Including Medicine		1,394,168.27	1,496,237.37	1,451,038.67	1,325,092.25	1,506,768.39	1,033,458.08	996,838.02	9,203,601.05
Case	Ranging amount	Limit amount	Rates
A	1 up to 49,999.99	50,000.00	0.00%	-	-	-	-	-	-	-	-
B	50,000 up to 99,999.99	100,000.00	3.00%	3,000.00	3,000.00	3,000.00	3,000.00	3,000.00	3,000.00	3,000.00	21,000.00
C	100,000 up to 149,999.99	150,000.00	4.50%	6,750.00	6,750.00	6,750.00	6,750.00	6,750.00	6,750.00	6,750.00	47,250.00
D	150,000 up to 199,999.99	200,000.00	5.00%	10,000.00	10,000.00	10,000.00	10,000.00	10,000.00	10,000.00	10,000.00	70,000.00
E	200,000 up to 249,999.99	250,000.00	5.50%	13,750.00	13,750.00	13,750.00	13,750.00	13,750.00	13,750.00	13,750.00	96,250.00
F	> 250, 000.00	250,001.00	6.50%	41,870.94	48,505.43	45,567.51	37,381.00	49,189.95	18,424.78	16,044.47	256,984.07
Total	1,000,001.00		75,370.94	82,005.43	79,067.51	70,881.00	82,689.95	51,924.78	49,544.47	491,484.07

<colgroup><col><col><col><col><col><col><col><col span="2"><col><col><col></colgroup><tbody>
</tbody>

 

[tygrrboi]

It is not clear what you are trying to do. Could you explain what part of that chart you hope to change/improve and the results you are expecting?