Spreadsheet: 883871d1732625084-embedded-if-function-with-isnumber-search-execl-help
Sheet: Sheet1

Category | Ours | Recharge | Gross Amount | VAT
HTP Application | 375 | 435 | 885 | if(ISNUMBER(SEARCH("HTP",$a2)),$b2*0.2,if(isnumber(search("Fee",$a2),0,if(isnumber)search("Fine",$a2),0,($b2-$b2/(1.2)))
HTP Renewal | 280 | 218 | 228
Fine | 250 | 0 | 250
Fine | 50 | 0 | 50
Appeal Fee | 575 | 0 | 575
HTP Application | 375 | 435 | 885
HTP Amendment/Variant | 90 | 218 | 326 |  |  |  |  |  |  | HTP | 20% of Our revenue
HTP Renewal | 280 | 218 | 228 |  |  |  |  |  |  | Fee | Zero
Starter Pack | 110 | 0 | 110 |  |  |  |  |  |  | Fine | Zero
[NAME] | 24 | 0 | 24 |  |  |  |  |  |  | Everything else | 0.2
HRCP | 36 | 0 | 36
[NAME] | 48 | 0 | 48
Starter Pack | 69 | 0 | 69
HTP Renewal | 280 | 218 | 554
[NAME] | 20 | 0 | 20
[NAME] | 48 | 0 | 48
[NAME] | 24 | 0 | 24
Fine | 39 | 0 | 39
Radio Licences | 10 | 0 | 10
HTP Application | 375 | 435 | 885
[NAME] | 24 | 0 | 24
[NAME] | 24 | 0 | 24
[NAME] | 24 | 0 | 24
[NAME] | 48 | 0 | 48
HTP Application | 375 | 435 | 885
HRVIF | 100 | 0 | 100
Appeal Fee | 895 | 0 | 895
ROPS Certificates | 842 | 0 | 842
Fine | 250 | 0 | 250
[NAME] | 24 | 0 | 24
Helmet Stickers | 12.5 | 0 | 12.5
Appeal Fee | 300 | 0 | 300
HTP Amendment/Variant | 90 | 218 | 242
Fine | 39 | 0 | 39
Fine | 500 | 0 | 500
National Court Fine | 250 | 0 | 250
[NAME] | 24 | 0 | 24
[NAME] | 24 | 0 | 24
National Court Fine + Costs | 1500 | 0 | 1500
HTP Application | 375 | 435 | 885
Fine | 39 | 0 | 39
HTP Renewal | 280 | 218 | 554
National Court Fine | 500 | 0 | 500
Fine | 300 | 0 | 300
Radio Licences | 5 | 0 | 5
Radio Licences | 75 | 0 | 75
Radio Licences | 170 | 0 | 170
Homologation Papers | 114 | 0 | 114
[NAME] | 168 | 0 | 168
CAT 2 Application | 288 | 0 | 288
HTP Application | 375 | 435 | 885
CAT 2 Application | 288 | 0 | 288
[NAME] | 24 | 0 | 24
[NAME] | 72 | 0 | 72
Fine | 300 | 0 | 300
HTP Application | 750 | 870 | 1770
Starter Pack | 69 | 0 | 69
Reopening of HTP Case | #N/A | #N/A | 430
[NAME] | 24 | 0 | 24
HTP Renewal | 560 | 436 | 1108
Radio Licences | 15 | 0 | 15
Radio Licences | 20 | 0 | 20
Metal Seals | 51 | 0 | 51
Fine | 300 | 0 | 300
ROPS Certificates | 250 | 0 | 250
[NAME] | 48 | 0 | 48
Metal Seals | 34 | 0 | 34
ROPS Certificates | 41 | 0 | 41
HRVIF | 100 | 0 | 100
Fine | 1150 | 0 | 1150
Fine & Appeal Fee | 550 | 0 | 550
Fine | 1800 | 0 | 1800
Helmet Stickers + Metal Seals | 34.99 | 0 | 34.99
ROPS Certificates | 30 | 0 | 30
ROPS Certificates | 30 | 0 | 30
Homologation Papers | 114 | 0 | 114
[NAME] | 24 | 0 | 24
ROPS Certificates | 150 | 0 | 150
HTP Application | 375 | 435 | 885
HRCP | 36 | 0 | 36
HRVIF | 200 | 0 | 200
Appeal Fee | 300 | 0 | 300
HTP Application | 375 | 435 | 885
HTP Application | 375 | 435 | 885
Fine | 150 | 0 | 150
HTP Application | 375 | 435 | 885
Radio Licences | 30 | 0 | 30
Radio Licences | 35 | 0 | 35
Reopening of HTP Case | #N/A | #N/A | 223
[NAME] | 24 | 0 | 24
Fine | 150 | 0 | 150
Appeal Fee | 895 | 0 | 895
Fine | 100 | 0 | 100
Helmet Stickers | 62.46 | 0 | 62.46
HRVIF Application | 100 | 0 | 100
Fine | 100 | 0 | 100
ROPS Certificates | 20 | 0 | 20
[NAME] | 72 | 0 | 72
HTP Application | 375 | 435 | 885
[NAME] | 24 | 0 | 24
HTP Amendment/Variant | 90 | 218 | 326
Starter Pack | 198 | 0 | 198
[NAME] | 48 | 0 | 48
Radio Licences | 5 | 0 | 5
Radio Licences | 45 | 0 | 45
Fine | 150 | 0 | 150
Fine | 1150 | 0 | 1150
Fine | 25 | 0 | 25
Fine | 225 | 0 | 225
Fine | 1150 | 0 | 1150
HRVIF Application | 100 | 0 | 100
ROPS Certificates | 80 | 0 | 80
HTP Application | 375 | 435 | 885
HTP Amendment/Variant | 90 | 218 | 326
Reopening of HTP Case | #N/A | #N/A | 217.5
ROPS Certificates | 80 | 0 | 80
Helmet Stickers | 12.5 | 0 | 12.5
[NAME] | 120.98 | 0 | 120.98
HRVIF | 100 | 0 | 100
Fine | 450 | 0 | 450
Radio Licences | 60 | 0 | 60
Radio Licences | 5 | 0 | 5
Fine | 25 | 0 | 25
Helmet Stickers | 37.5 | 0 | 37.5
[NAME] | 24 | 0 | 24
Fine | 50 | 0 | 50
Fine | 75 | 0 | 75
[NAME] | 24 | 0 | 24
[NAME] | 24 | 0 | 24
Fine | 150 | 0 | 150
[NAME] | 97.96 | 0 | 97.96
[NAME] | 48 | 0 | 48
[NAME] | 24 | 0 | 24
[NAME] | 24 | 0 | 24
Helmet Stickers | 25 | 0 | 25
Reopening of HTP Case | #N/A | #N/A | 217.5
Fine | 150 | 0 | 150
[NAME] | 48 | 0 | 48
HTP Application | 375 | 435 | 885
Radio Licences | 10 | 0 | 10
Radio Licences | 65 | 0 | 65
[NAME] | 48 | 0 | 48
Fine | 50 | 0 | 50
[NAME] | 48 | 0 | 48
Fine | 75 | 0 | 75
Fine | 100 | 0 | 100
Fine | 100 | 0 | 100
HRVIF | 100 | 0 | 100
Reopening of HTP Case | #N/A | #N/A | 217.5
Fine | 150 | 0 | 150
HRVIF | 100 | 0 | 100
HTP Application | 375 | 435 | 885
Appeal Fee | 300 | 0 | 300
Homologation Papers | 32 | 0 | 32
Appeal Fee | 300 | 0 | 300
HTP Application | 375 | 435 | 643
HRVIF | 100 | 0 | 100
Fine | 150 | 0 | 150
HTP Application | 375 | 435 | 885
HTP Application | 375 | 435 | 885
Warning Signs | 60 | 0 | 60
HTP Renewal | 280 | 218 | 554
HTP Renewal | 280 | 218 | 554
Helmet Stickers | 37.48 | 0 | 37.48
HTP Renewal | 280 | 218 | 554
Helmet Stickers | 62.5 | 0 | 62.5
[NAME] | 24 | 0 | 24
Fine | 75 | 0 | 75
ROPS Certificates | 412 | 0 | 412
Appeal Fee | 300 | 0 | 300
HTP Renewal | 280 | 218 | 326
HTP Amendment/Variant | 90 | 218 | 326
HTP Renewal | 280 | 218 | 554
Reopening of HTP Case | #N/A | #N/A | 217.5
Fine | 25 | 0 | 25
Fine | 75 | 0 | 75
Reopening of HTP Case | #N/A | #N/A | 217.5
Starter Pack | 220 | 0 | 220
Helmet Stickers | 25 | 0 | 25
[NAME] | 48 | 0 | 48
[NAME] | 24 | 0 | 24
HTP Application | 375 | 435 | 885
HTP Application | 375 | 435 | 885
HTP Renewal | 280 | 218 | 554
[NAME] | 48 | 0 | 48
HTP Renewal | 280 | 218 | 554
[NAME] | 120 | 0 | 120
HTP Renewal | 280 | 218 | 554
ROPS Certificates | 308.1 | 0 | 308.1
HTP Renewal | 280 | 218 | 554
[NAME] | 24 | 0 | 24
[NAME] | 20 | 0 | 20
[NAME] | 192 | 0 | 192
HRCP | 36 | 0 | 36
ROPS Certificates | 30 | 0 | 30
Fine | 250 | 0 | 250
Helmet Stickers | 75 | 0 | 75
HTP Renewal | 280 | 218 | 554
[NAME] | 24 | 0 | 24
ROPS Certificates | 1025 | 0 | 1025
Radio Licences | 45 | 0 | 45
Fine | 250 | 0 | 250
HTP Application | 375 | 435 | 885
HTP Amendment/Variant | 90 | 218 | 326
HTP Application | 375 | 435 | 885
[NAME] | 48 | 0 | 48
HTP Application | 375 | 435 | 885
HRVIF Application | 100 | 0 | 100
Starter Pack | 110 | 0 | 110
HTP Renewal | 280 | 218 | 554
Homologation Papers | 47 | 0 | 47
Roll Cage Certificates | 80 | 0 | 80
HTP Renewal | 280 | 218 | 554
Starter Pack | 220 | 0 | 220
HRVIF Application | 100 | 0 | 100
HTP Application | 750 | 870 | 1770
HTP Application | 375 | 435 | 885
HTP Renewal | 840 | 654 | 1662
Appeal Fee | 300 | 0 | 300
Homologation Papers | 31 | 0 | 31
HTP Application | 375 | 435 | 885
HTP Amendment/Variant | 90 | 218 | 326
[NAME] | 24 | 0 | 24
HTP Application | 375 | 435 | 885
 | 2096 | 0 | 2096
HTP Application | 375 | 435 | 885
Helmet Stickers | 25 | 0 | 25
HTP Application | 375 | 435 | 885
Radio Licences | 10 | 0 | 10
HTP Renewal | 1120 | 872 | 2216
CAT 2 Application | 576 | 0 | 576
HTP Application | 375 | 435 | 885
[NAME] | 24 | 0 | 24
CAT 2 Application | 288 | 0 | 288
HTP Renewal | 280 | 218 | 554
CAT 2 Application | 288 | 0 | 288
[NAME] | 24 | 0 | 24
[NAME] | 48 | 0 | 48
[NAME] | 40 | 0 | 40
HRVIF Application | 100 | 0 | 100
HRVIF Application | 100 | 0 | 100
Starter Pack | 110 | 0 | 110
HTP Amendment/Variant | 90 | 218 | 326
HRVIF Application | 100 | 0 | 100
HTP Application | 375 | 435 | 885
Appeal Fee | 575 | 0 | 575
Appeal Fee | 895 | 0 | 895
Fine | 1150 | 0 | 1150
Radio Licences | 175 | 0 | 175
Radio Licences | 5 | 0 | 5
HTP Application | 375 | 435 | 885
 | 217.5 | 0 | 217.5
HTP Application | 375 | 435 | 885
[NAME] | 24 | 0 | 24
HTP Renewal | 280 | 218 | 554
[NAME] | 72 | 0 | 72
HTP Application | 375 | 435 | 885
[NAME] | 24 | 0 | 24
Fine | 50 | 0 | 50
 | 235 | 0 | 235
Homologation Papers | 47 | 0 | 47
HTP Renewal | 280 | 218 | 554
HTP Renewal | 280 | 218 | 554
HTP Application | 750 | 870 | 1770
HRVIF Application | 100 | 0 | 100
CAT 2 Application | 288 | 0 | 288
HTP Application | 375 | 435 | 885
HTP Application | 750 | 870 | 1770
HRCP | 36 | 0 | 36
HTP Renewal | 0 | 0 | 885
Helmet Stickers | 25 | 0 | 25
HTP Renewal | 0 | 0 | 554
[NAME] | 48 | 0 | 48
[NAME] | 48 | 0 | 48
 | 435 | 0 | 435
[NAME] | 120 | 0 | 120
HTP Application | 0 | 0 | 885
Radio Licences | 15 | 0 | 15
Radio Licences | 10 | 0 | 10
Starter Pack | 176 | 0 | 176
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
HTP Renewal