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.

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

 

[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?