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.
<colgroup><col><col><col><col><col><col><col><col span="2"><col><col><col></colgroup><tbody>
</tbody>
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>