Code:
awk '
BEGIN {FS = OFS = ";"
print "Reference;EAN;Condition;Stock;Price;Deliverycode;;manufacturer;Titel;MPN;supplier_code;Sup Category;Category 2;Cost;Marge;DSCost;Vast Comm;Vari Comm;;;;Marge Berekend;CMD;CMD + Comm"
}
{ if ($14 <= 0.99 && $14 >= 0.01)
print $0,"6";
else if ($14 <= 1.99 && $14 >= 1)
print $0,"5";
else if ($14 <= 2.99 && $14 >= 2)
print $0,"3";
else if ($14 <= 3.99 && $14 >= 3)
print $0,"2.5";
else if ($14 <= 4.99 && $14 >= 4)
print $0,"2";
else if ($14 <= 5.99 && $14 >= 5)
print $0,"2";
else if ($14 <= 6.99 && $14 >= 6)
print $0,"0.85";
else if ($14 <= 7.99 && $14 >= 7)
print $0,"0.7";
else if ($14 <= 8.99 && $14 >= 8)
print $0,"0.65";
else if ($14 <= 9.99 && $14 >= 9)
print $0,"0.55";
else if ($14 <= 10.99 && $14 >= 10)
print $0,"0.5";
else if ($14 <= 11.99 && $14 >= 11)
print $0,"0.45";
else if ($14 <= 12.99 && $14 >= 12)
print $0,"0.41";
else if ($14 <= 13.99 && $14 >= 13)
print $0,"0.38";
else if ($14 <= 14.99 && $14 >= 14)
print $0,"0.35";
else if ($14 <= 15.99 && $14 >= 15)
print $0,"0.33";
else if ($14 <= 16.99 && $14 >= 16)
print $0,"0.31";
else if ($14 <= 17.99 && $14 >= 17)
print $0,"0.29";
else if ($14 <= 18.99 && $14 >= 18)
print $0,"0.28";
else if ($14 <= 19.99 && $14 >= 19)
print $0,"0.26";
else if ($14 <= 24.99 && $14 >= 20)
print $0,"0.25";
else if ($14 <= 29.99 && $14 >= 25)
print $0,"0.24";
else if ($14 <= 34.99 && $14 >= 30)
print $0,"0.17";
else if ($14 <= 39.99 && $14 >= 35)
print $0,"0.15";
else if ($14 <= 44.99 && $14 >= 40)
print $0,"0.13";
else if ($14 <= 49.99 && $14 >= 45)
print $0,"0.12";
else if ($14 <= 54.99 && $14 >= 50)
print $0,"0.1";
else if ($14 <= 59.99 && $14 >= 55)
print $0,"0.08";
else if ($14 <= 64.99 && $14 >= 60)
print $0,"0.08";
else if ($14 <= 69.99 && $14 >= 65)
print $0,"0.08";
else if ($14 <= 74.99 && $14 >= 70)
print $0,"0.08";
else if ($14 <= 79.99 && $14 >= 75)
print $0,"0.08";
else if ($14 <= 84.99 && $14 >= 80)
print $0,"0.08";
else if ($14 <= 89.99 && $14 >= 85)
print $0,"0.08";
else if ($14 <= 94.99 && $14 >= 90)
print $0,"0.08";
else if ($14 <= 99.99 && $14 >= 95)
print $0,"0.08";
else if ($14 <= 109.99 && $14 >= 100)
print $0,"0.07";
else if ($14 <= 119.99 && $14 >= 110)
print $0,"0.07";
else if ($14 <= 129.99 && $14 >= 120)
print $0,"0.07";
else if ($14 <= 139.99 && $14 >= 130)
print $0,"0.07";
else if ($14 <= 149.99 && $14 >= 140)
print $0,"0.07";
else if ($14 <= 159.99 && $14 >= 150)
print $0,"0.07";
else if ($14 <= 169.99 && $14 >= 160)
print $0,"0.07";
else if ($14 <= 179.99 && $14 >= 170)
print $0,"0.07";
else if ($14 <= 189.99 && $14 >= 180)
print $0,"0.07";
else if ($14 <= 199.99 && $14 >= 190)
print $0,"0.07";
else if ($14 <= 209.99 && $14 >= 200)
print $0,"0.07";
else if ($14 <= 219.99 && $14 >= 210)
print $0,"0.07";
else if ($14 <= 229.99 && $14 >= 220)
print $0,"0.07";
else if ($14 <= 239.99 && $14 >= 230)
print $0,"0.07";
else if ($14 <= 249.99 && $14 >= 240)
print $0,"0.07";
else if ($14 <= 299.99 && $14 >= 250)
print $0,"0.06";
else if ($14 <= 349.99 && $14 >= 300)
print $0,"0.06";
else if ($14 <= 399.99 && $14 >= 350)
print $0,"0.06";
else if ($14 <= 449.99 && $14 >= 400)
print $0,"0.06";
else if ($14 <= 499.99 && $14 >= 450)
print $0,"0.06";
else if ($14 <= 549.99 && $14 >= 500)
print $0,"0.06";
else if ($14 <= 599.99 && $14 >= 550)
print $0,"0.06";
else if ($14 <= 649.99 && $14 >= 600)
print $0,"0.06";
else if ($14 <= 699.99 && $14 >= 650)
print $0,"0.06";
else if ($14 <= 749.99 && $14 >= 700)
print $0,"0.06";
else if ($14 <= 799.99 && $14 >= 750)
print $0,"0.06";
#else if ($14 <= 849.99 && $14 >= 800)
# print $0,"0.06";
#else if ($14 <= 899.99 && $14 >= 850)
# print $0,"0.06";
#else if ($14 <= 949.99 && $14 >= 900)
# print $0,"0.06";
#else if ($14 <= 999.99 && $14 >= 950)
# print $0,"0.06";
#else if ($14 <= 9999.99 && $14 >= 1000)
# print $0,"0.06";
else
print;
}
' $1 > $2