Spreadsheet: 480849d1474104774-if-or-true-statement-for-choosing-the-currency-to-calculate-exchange-rates-currency-added-costing-format-2-1
Sheet: INVOICE PRICE

 | USD |  |  | RATES | 362 | 450 | 500
 |  |  |  | MARK-UP | 0.05 |  | CUSTOMER |  |  | £ | €
 |  |  |  | WHT | 0.05
S/N | [NAME] | CUR | OEM COST | L/C | EXTRA COST | FREIGHT | CIF | ONSHORE | COST OF FUNDS | MARK-UP | WHT | TOTAL
1 | BAG 1 | $ | 5000 | 50 |  | 500 | 5550 | 2009100 | 0 | 100455 | 105477.75 | 2215032.75
2 | BAG 2 | £ | 6000 | 60 | 0 |  | 6060 | 2193720 | 0 | 109686 | 115170.3 | 2418576.3
3 | BAG 3 | € | 7000 | 70 | 0 |  | 7070 | 2559340 | 0 | 127967 | 134365.35 | 2821672.35
4 |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0
5 |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0
6 |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0
7 |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0
8 |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0
9 |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0
10 |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0
5 |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0
6 |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0
7 |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0
8 |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0
9 |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0
10 |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0
11 |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0
12 |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0
13 |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0
14 |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0
15 |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0
16 |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0
17 |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0
18 |  |  |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 18000 |  | 0 |  |  |  | 0 | 338108 |  | 7455281.4
 | GBP |  |  | RATE | 530 |  |  |  |  | 1690540
 |  |  |  | MARK-UP | 0.2
 |  |  |  | WHT | 0.05
S/N | [NAME] |  | OEM COST | L/C | EXTRA COST | FREIGHT | CIF | ONSHORE | COST OF FUNDS | MARK-UP | WHT | TOTAL
1 | FLIR P660 |  | 27904.8 | 279.048 | 150 | 60 | 28393.848 | 15048739.44 | 0 | 3009747.888 | 902924.3664000002 | 18961411.6944 |  |  | 0.005
2 |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 139.524
3 |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 6.578947368421052
4 |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 146.102947368421
5 |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0
6 |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0
7 |  |  |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0
8 |  |  |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0
9 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
10 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
11 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
12 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
13 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
14 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
15 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
16 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
17 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
18 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
19 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
20 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
21 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
22 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
23 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
24 |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0
 | EUR |  |  | RATE | 396
 |  |  |  | MARK-UP | 0.05 |  | UNILEVER
 |  |  |  | WHT | 0.05
S/N | [NAME] |  | OEM COST | L/C | EXTRA COST | FREIGHT | CIF | ONSHORE | COST OF FUNDS | MARK-UP | WHT | TOTAL
1 | SFX 32 |  | 32815 | 328.15 | 150 | 1300 | 34593.15 | 13698887.4 | 0 | 684944.3700000001 | 719191.5885000001 | 15103023.3585
2 | DIGIPHONE PLUS |  | 5079 | 50.79 | 0 | 0 | 5129.79 | 2031396.84 | 0 | 101569.842 | 106648.3341 | 2239615.0161
3 |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0
4 |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0
5 |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0
6 |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0
7 |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0
8 |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0
9 |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0
10 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
11 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
12 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
13 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
14 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
15 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
16 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
17 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
18 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
19 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
20 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
21 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
22 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
#N/A | TEST |  |  | 0 |  | 20 | 20 | 7920 | 424.0671780821918 | 417.2033589041096 | 438.0635268493151 | 9199.334063835617
 |  |  | 37894
 | [NAME] |  |  | RATE | 1
 |  |  |  | MARK-UP | 0.2
 |  |  |  | WHT | 0.05
S/N | [NAME] |  | OEM COST | L/C | EXTRA COST | FREIGHT | CIF | ONSHORE | COST OF FUNDS | MARK-UP | WHT | TOTAL
1 | FLUKE 1621 |  | 263670 | 0 |  |  | 263670 | 263670 | 0 | 52734 | 15820.2 | 332224.2
2 | FLUKE 177 |  | 117000 |  |  | 0 | 117000 | 117000 | 0 | 23400 | 7020 | 147420
3 | FLUKE 113 |  | 50160 |  |  |  | 50160 | 50160 | 0 | 10032 | 3009.6 | 63201.6
4 | FLUKE 376 |  | 174570 |  |  |  | 174570 | 174570 | 0 | 34914 | 10474.2 | 219958.2
5 | FLUKE 1503 |  | 164670 |  |  |  | 164670 | 164670 | 0 | 32934 | 9880.2 | 207484.2
6 |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
7 |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
8 |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
9 |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
10 |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
11 |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
12 |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
13 |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
14 |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
15 |  |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0
16 |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
17 |  |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0
18 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
19 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
20 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
21 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
22 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
23 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
24 | TEST |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 770070 |  |  | 0 |  |  |  | 154014 | 46204.2