Hi Guys,
as indicated, the numbers marked in red are the expect results, process and registration fee will be extracted from table 3 and cost will be extracted from table 2; couldn't really pinpoint what formula to use, a few look ups ?
could you help me with any formulas with regard to this?
Table 1
<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Table 2
<colgroup><col><col><col><col span="2"></colgroup><tbody>
</tbody>
Table 3
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
any assistance will be greatly appreciated !
as indicated, the numbers marked in red are the expect results, process and registration fee will be extracted from table 3 and cost will be extracted from table 2; couldn't really pinpoint what formula to use, a few look ups ?
could you help me with any formulas with regard to this?
Table 1
Serial number | Process fee | Registration fee | Process cost | Registration cost | |||
123525 | 5245+5647-5475 | 5648 | 5245+5647+5475 | 5648 | |||
126542 | 5415 | 4512 | |||||
124562 | |||||||
124851 | |||||||
124487 | |||||||
589581C | |||||||
V15689 | 4526-4562 | 4526+4562 |
<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Table 2
Serial number | Invoice number | Description | Customer | Amount |
123525 | 1562 | Process fee_04.18-06.18.2018_SN_123525 | A | 5245 |
1895 | registration fee_04.18-06.18.2018_SN_123525 | A | 5648 | |
4589 | Process fee_04.18-06.18.2018_SN_123525 | A | 5647 | |
MJJK-221 | Process fee_04.18-06.18.2018_SN_123525 | A | 5475 | |
126542 | 5652 | Process fee_04.18-06.18.2018_SN_126542 | B | 5415 |
2452 | registration fee_04.18-06.18.2018_SN_126542 | B | 4512 | |
124562 | 2154 | Process fee_04.18-06.18.2018_SN_124562 | C | 5541 |
5541 | registration fee_04.18-06.18.2018_SN_124562 | C | 412 | |
124851 | 5412 | Process fee_04.18-06.18.2018_SN_124851 | D | 451 |
4545 | registration fee_04.18-06.18.2018_SN_124851 | D | 2562 | |
124487 | 4654 | Process fee_04.18-06.18.2018_SN_124487 | E | 5412 |
45JJa | registration fee_04.18-06.18.2018_SN_124487 | E | 4515 | |
589581C | 568 | Process fee_04.18-06.18.2018_SN_589581C | F | 4514 |
V15689 | 2018965 | registration fee_04.18-06.18.2018_SN_V15689 | G | 4526 |
<colgroup><col><col><col><col span="2"></colgroup><tbody>
</tbody>
Table 3
Serial number | invoice number | description | customer | amount |
123525 | 12RD000451 | Process fee_04.18-06.18.2018_SN_123525 | A | 5245 |
12MD000541 | registration fee_04.18-06.18.2018_SN_123525 | A | 5648 | |
12RD000457 | Process fee_04.18-06.18.2018_SN_123525 | A | 5647 | |
12RC000548 | Process fee_04.18-06.18.2018_SN_123525 | A | 5475 | |
126542 | 12RD000452 | Process fee_04.18-06.18.2018_SN_126542 | B | 5415 |
12MD000542 | registration fee_04.18-06.18.2018_SN_126542 | B | 4512 | |
124562 | 12RD000453 | Process fee_04.18-06.18.2018_SN_124562 | C | 5541 |
12MD000543 | registration fee_04.18-06.18.2018_SN_124562 | C | 412 | |
124851 | 12RD000454 | Process fee_04.18-06.18.2018_SN_124851 | D | 451 |
12MD000544 | registration fee_04.18-06.18.2018_SN_124851 | D | 2562 | |
124487 | 12RD000455 | Process fee_04.18-06.18.2018_SN_124487 | E | 5412 |
12MD000545 | registration fee_04.18-06.18.2018_SN_124487 | E | 4515 | |
589581C | 12RD000456 | Process fee_04.18-06.18.2018_SN_589581C | F | 4514 |
V15689 | 12MD000546 | registration fee_04.18-06.18.2018_SN_V15689 | G | 4526 |
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
any assistance will be greatly appreciated !