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
[TABLE="width: 1333"]
<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Serial number[/TD]
[TD]Process fee[/TD]
[TD]Registration fee[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Process cost[/TD]
[TD]Registration cost[/TD]
[/TR]
[TR]
[TD="align: right"]123525[/TD]
[TD="align: right"]5245+5647-5475[/TD]
[TD="align: right"]5648[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]5245+5647+5475[/TD]
[TD="align: right"]5648[/TD]
[/TR]
[TR]
[TD="align: right"]126542[/TD]
[TD="align: right"]5415[/TD]
[TD="align: right"]4512[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]124562[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]124851[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]124487[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]589581C[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]V15689[/TD]
[TD][/TD]
[TD]4526-4562[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]4526+4562[/TD]
[/TR]
</tbody>[/TABLE]
Table 2
[TABLE="width: 938"]
<colgroup><col><col><col><col span="2"></colgroup><tbody>[TR]
[TD]Serial number[/TD]
[TD]Invoice number[/TD]
[TD]Description[/TD]
[TD]Customer[/TD]
[TD]Amount[/TD]
[/TR]
[TR]
[TD="align: right"]123525[/TD]
[TD="align: right"]1562[/TD]
[TD]Process fee_04.18-06.18.2018_SN_123525[/TD]
[TD]A[/TD]
[TD="align: right"]5245[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]1895[/TD]
[TD]registration fee_04.18-06.18.2018_SN_123525[/TD]
[TD]A[/TD]
[TD="align: right"]5648[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]4589[/TD]
[TD]Process fee_04.18-06.18.2018_SN_123525[/TD]
[TD]A[/TD]
[TD="align: right"]5647[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]MJJK-221[/TD]
[TD]Process fee_04.18-06.18.2018_SN_123525[/TD]
[TD]A[/TD]
[TD="align: right"]5475[/TD]
[/TR]
[TR]
[TD="align: right"]126542[/TD]
[TD="align: right"]5652[/TD]
[TD]Process fee_04.18-06.18.2018_SN_126542[/TD]
[TD]B[/TD]
[TD="align: right"]5415[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]2452[/TD]
[TD]registration fee_04.18-06.18.2018_SN_126542[/TD]
[TD]B[/TD]
[TD="align: right"]4512[/TD]
[/TR]
[TR]
[TD="align: right"]124562[/TD]
[TD="align: right"]2154[/TD]
[TD]Process fee_04.18-06.18.2018_SN_124562[/TD]
[TD]C[/TD]
[TD="align: right"]5541[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]5541[/TD]
[TD]registration fee_04.18-06.18.2018_SN_124562[/TD]
[TD]C[/TD]
[TD="align: right"]412[/TD]
[/TR]
[TR]
[TD="align: right"]124851[/TD]
[TD="align: right"]5412[/TD]
[TD]Process fee_04.18-06.18.2018_SN_124851[/TD]
[TD]D[/TD]
[TD="align: right"]451[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]4545[/TD]
[TD]registration fee_04.18-06.18.2018_SN_124851[/TD]
[TD]D[/TD]
[TD="align: right"]2562[/TD]
[/TR]
[TR]
[TD="align: right"]124487[/TD]
[TD="align: right"]4654[/TD]
[TD]Process fee_04.18-06.18.2018_SN_124487[/TD]
[TD]E[/TD]
[TD="align: right"]5412[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]45JJa[/TD]
[TD]registration fee_04.18-06.18.2018_SN_124487[/TD]
[TD]E[/TD]
[TD="align: right"]4515[/TD]
[/TR]
[TR]
[TD]589581C[/TD]
[TD="align: right"]568[/TD]
[TD]Process fee_04.18-06.18.2018_SN_589581C[/TD]
[TD]F[/TD]
[TD="align: right"]4514[/TD]
[/TR]
[TR]
[TD]V15689[/TD]
[TD="align: right"]2018965[/TD]
[TD]registration fee_04.18-06.18.2018_SN_V15689[/TD]
[TD]G[/TD]
[TD="align: right"]4526[/TD]
[/TR]
</tbody>[/TABLE]
Table 3
[TABLE="width: 918"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD="align: right"]Serial number[/TD]
[TD]invoice number[/TD]
[TD]description[/TD]
[TD]customer[/TD]
[TD="align: right"]amount[/TD]
[/TR]
[TR]
[TD="align: right"]123525[/TD]
[TD]12RD000451[/TD]
[TD]Process fee_04.18-06.18.2018_SN_123525[/TD]
[TD]A[/TD]
[TD="align: right"]5245[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]12MD000541[/TD]
[TD]registration fee_04.18-06.18.2018_SN_123525[/TD]
[TD]A[/TD]
[TD="align: right"]5648[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]12RD000457[/TD]
[TD]Process fee_04.18-06.18.2018_SN_123525[/TD]
[TD]A[/TD]
[TD="align: right"]5647[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]12RC000548[/TD]
[TD]Process fee_04.18-06.18.2018_SN_123525[/TD]
[TD]A[/TD]
[TD="align: right"]5475[/TD]
[/TR]
[TR]
[TD="align: right"]126542[/TD]
[TD]12RD000452[/TD]
[TD]Process fee_04.18-06.18.2018_SN_126542[/TD]
[TD]B[/TD]
[TD="align: right"]5415[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]12MD000542[/TD]
[TD]registration fee_04.18-06.18.2018_SN_126542[/TD]
[TD]B[/TD]
[TD="align: right"]4512[/TD]
[/TR]
[TR]
[TD="align: right"]124562[/TD]
[TD]12RD000453[/TD]
[TD]Process fee_04.18-06.18.2018_SN_124562[/TD]
[TD]C[/TD]
[TD="align: right"]5541[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]12MD000543[/TD]
[TD]registration fee_04.18-06.18.2018_SN_124562[/TD]
[TD]C[/TD]
[TD="align: right"]412[/TD]
[/TR]
[TR]
[TD="align: right"]124851[/TD]
[TD]12RD000454[/TD]
[TD]Process fee_04.18-06.18.2018_SN_124851[/TD]
[TD]D[/TD]
[TD="align: right"]451[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]12MD000544[/TD]
[TD]registration fee_04.18-06.18.2018_SN_124851[/TD]
[TD]D[/TD]
[TD="align: right"]2562[/TD]
[/TR]
[TR]
[TD="align: right"]124487[/TD]
[TD]12RD000455[/TD]
[TD]Process fee_04.18-06.18.2018_SN_124487[/TD]
[TD]E[/TD]
[TD="align: right"]5412[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]12MD000545[/TD]
[TD]registration fee_04.18-06.18.2018_SN_124487[/TD]
[TD]E[/TD]
[TD="align: right"]4515[/TD]
[/TR]
[TR]
[TD]589581C[/TD]
[TD]12RD000456[/TD]
[TD]Process fee_04.18-06.18.2018_SN_589581C[/TD]
[TD]F[/TD]
[TD="align: right"]4514[/TD]
[/TR]
[TR]
[TD]V15689[/TD]
[TD]12MD000546[/TD]
[TD]registration fee_04.18-06.18.2018_SN_V15689[/TD]
[TD]G[/TD]
[TD="align: right"]4526[/TD]
[/TR]
</tbody>[/TABLE]
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
[TABLE="width: 1333"]
<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Serial number[/TD]
[TD]Process fee[/TD]
[TD]Registration fee[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Process cost[/TD]
[TD]Registration cost[/TD]
[/TR]
[TR]
[TD="align: right"]123525[/TD]
[TD="align: right"]5245+5647-5475[/TD]
[TD="align: right"]5648[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]5245+5647+5475[/TD]
[TD="align: right"]5648[/TD]
[/TR]
[TR]
[TD="align: right"]126542[/TD]
[TD="align: right"]5415[/TD]
[TD="align: right"]4512[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]124562[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]124851[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]124487[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]589581C[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]V15689[/TD]
[TD][/TD]
[TD]4526-4562[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]4526+4562[/TD]
[/TR]
</tbody>[/TABLE]
Table 2
[TABLE="width: 938"]
<colgroup><col><col><col><col span="2"></colgroup><tbody>[TR]
[TD]Serial number[/TD]
[TD]Invoice number[/TD]
[TD]Description[/TD]
[TD]Customer[/TD]
[TD]Amount[/TD]
[/TR]
[TR]
[TD="align: right"]123525[/TD]
[TD="align: right"]1562[/TD]
[TD]Process fee_04.18-06.18.2018_SN_123525[/TD]
[TD]A[/TD]
[TD="align: right"]5245[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]1895[/TD]
[TD]registration fee_04.18-06.18.2018_SN_123525[/TD]
[TD]A[/TD]
[TD="align: right"]5648[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]4589[/TD]
[TD]Process fee_04.18-06.18.2018_SN_123525[/TD]
[TD]A[/TD]
[TD="align: right"]5647[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]MJJK-221[/TD]
[TD]Process fee_04.18-06.18.2018_SN_123525[/TD]
[TD]A[/TD]
[TD="align: right"]5475[/TD]
[/TR]
[TR]
[TD="align: right"]126542[/TD]
[TD="align: right"]5652[/TD]
[TD]Process fee_04.18-06.18.2018_SN_126542[/TD]
[TD]B[/TD]
[TD="align: right"]5415[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]2452[/TD]
[TD]registration fee_04.18-06.18.2018_SN_126542[/TD]
[TD]B[/TD]
[TD="align: right"]4512[/TD]
[/TR]
[TR]
[TD="align: right"]124562[/TD]
[TD="align: right"]2154[/TD]
[TD]Process fee_04.18-06.18.2018_SN_124562[/TD]
[TD]C[/TD]
[TD="align: right"]5541[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]5541[/TD]
[TD]registration fee_04.18-06.18.2018_SN_124562[/TD]
[TD]C[/TD]
[TD="align: right"]412[/TD]
[/TR]
[TR]
[TD="align: right"]124851[/TD]
[TD="align: right"]5412[/TD]
[TD]Process fee_04.18-06.18.2018_SN_124851[/TD]
[TD]D[/TD]
[TD="align: right"]451[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]4545[/TD]
[TD]registration fee_04.18-06.18.2018_SN_124851[/TD]
[TD]D[/TD]
[TD="align: right"]2562[/TD]
[/TR]
[TR]
[TD="align: right"]124487[/TD]
[TD="align: right"]4654[/TD]
[TD]Process fee_04.18-06.18.2018_SN_124487[/TD]
[TD]E[/TD]
[TD="align: right"]5412[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]45JJa[/TD]
[TD]registration fee_04.18-06.18.2018_SN_124487[/TD]
[TD]E[/TD]
[TD="align: right"]4515[/TD]
[/TR]
[TR]
[TD]589581C[/TD]
[TD="align: right"]568[/TD]
[TD]Process fee_04.18-06.18.2018_SN_589581C[/TD]
[TD]F[/TD]
[TD="align: right"]4514[/TD]
[/TR]
[TR]
[TD]V15689[/TD]
[TD="align: right"]2018965[/TD]
[TD]registration fee_04.18-06.18.2018_SN_V15689[/TD]
[TD]G[/TD]
[TD="align: right"]4526[/TD]
[/TR]
</tbody>[/TABLE]
Table 3
[TABLE="width: 918"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD="align: right"]Serial number[/TD]
[TD]invoice number[/TD]
[TD]description[/TD]
[TD]customer[/TD]
[TD="align: right"]amount[/TD]
[/TR]
[TR]
[TD="align: right"]123525[/TD]
[TD]12RD000451[/TD]
[TD]Process fee_04.18-06.18.2018_SN_123525[/TD]
[TD]A[/TD]
[TD="align: right"]5245[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]12MD000541[/TD]
[TD]registration fee_04.18-06.18.2018_SN_123525[/TD]
[TD]A[/TD]
[TD="align: right"]5648[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]12RD000457[/TD]
[TD]Process fee_04.18-06.18.2018_SN_123525[/TD]
[TD]A[/TD]
[TD="align: right"]5647[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]12RC000548[/TD]
[TD]Process fee_04.18-06.18.2018_SN_123525[/TD]
[TD]A[/TD]
[TD="align: right"]5475[/TD]
[/TR]
[TR]
[TD="align: right"]126542[/TD]
[TD]12RD000452[/TD]
[TD]Process fee_04.18-06.18.2018_SN_126542[/TD]
[TD]B[/TD]
[TD="align: right"]5415[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]12MD000542[/TD]
[TD]registration fee_04.18-06.18.2018_SN_126542[/TD]
[TD]B[/TD]
[TD="align: right"]4512[/TD]
[/TR]
[TR]
[TD="align: right"]124562[/TD]
[TD]12RD000453[/TD]
[TD]Process fee_04.18-06.18.2018_SN_124562[/TD]
[TD]C[/TD]
[TD="align: right"]5541[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]12MD000543[/TD]
[TD]registration fee_04.18-06.18.2018_SN_124562[/TD]
[TD]C[/TD]
[TD="align: right"]412[/TD]
[/TR]
[TR]
[TD="align: right"]124851[/TD]
[TD]12RD000454[/TD]
[TD]Process fee_04.18-06.18.2018_SN_124851[/TD]
[TD]D[/TD]
[TD="align: right"]451[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]12MD000544[/TD]
[TD]registration fee_04.18-06.18.2018_SN_124851[/TD]
[TD]D[/TD]
[TD="align: right"]2562[/TD]
[/TR]
[TR]
[TD="align: right"]124487[/TD]
[TD]12RD000455[/TD]
[TD]Process fee_04.18-06.18.2018_SN_124487[/TD]
[TD]E[/TD]
[TD="align: right"]5412[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]12MD000545[/TD]
[TD]registration fee_04.18-06.18.2018_SN_124487[/TD]
[TD]E[/TD]
[TD="align: right"]4515[/TD]
[/TR]
[TR]
[TD]589581C[/TD]
[TD]12RD000456[/TD]
[TD]Process fee_04.18-06.18.2018_SN_589581C[/TD]
[TD]F[/TD]
[TD="align: right"]4514[/TD]
[/TR]
[TR]
[TD]V15689[/TD]
[TD]12MD000546[/TD]
[TD]registration fee_04.18-06.18.2018_SN_V15689[/TD]
[TD]G[/TD]
[TD="align: right"]4526[/TD]
[/TR]
</tbody>[/TABLE]
any assistance will be greatly appreciated !