convert functions Excel to access

[azhar2006]

How to convert these functions from Excel, to access
=(INDEX(Baremes!$B$5:$R$21;F4;2))*45

=(INDEX(Baremes!$B$5:$R$21;IF($D$7=1;$F$7;$F$4);$F$5+3))*45

=IF($F$4>=9;($N$4+$N$5)*$N$7/100;0)

=IF($H$10=1;($N$17+$N$18)*10/100;0)



=IF($N$7>0;INDEX('95-28 et 95-300'!$E$2:$E$224;$E$9);0)

=(VLOOKUP($N$3;AncienBareme;12))*INDEX(Divers!$K$2:$K$11;$H$9;1)/100

=(K3+K4)*(INDEX(Grades!$F$3:$F$74;$D$2;1))/100

=($K$3+$K$4)*(INDEX(Grades!$G$3:$G$74;$D$2;1))/100

=IF($D$4=2;0;IF($D$6=1;0;IF($H$6=0;5.5;800)))

=((ROUND(K23/10;0))*10)*9/100

=(IF(N23>120000;29500+(N23-120000)*0.35;IF(N23>30000;2500+(N23-30000)*0.3;IF(N23>28750;2250+(N23-28750)*0.2;IF(N23>22500;1500+(N23-22500)*0.12;IF(N23>15000;(N23-15000)*0.2;0))))))

=IF(OR(N7=35;N7=45;N7=80;N7=90);1;0)

=(((VLOOKUP(IF($D$7=1;$N$6;$N$3);AncienBareme;13))*(VLOOKUP(IF($D$7=1;$N$6;$N$3);AncienBareme;(IF($F$5>10;10;$F$5))+14))))

=IF(AND($F$4>=9;$F$4<=11);INDEX('95-28 et 95-300'!$D$2:$D$224;$E$9;1);0)

=INDEX(Divers!$K$2:$K$11;$H$9;1)

=VALUE((LEFT($H$7;LEN($H$7)-2)&RIGHT($H$7)))

=(((VLOOKUP(IF($D$7=1;$N$6;$N$3);AncienBareme;13))*(VLOOKUP(IF($D$7=1;$N$6;$N$3);AncienBareme;(IF($F$5>10;10;$F$5))+14))))

=VALUE((LEFT($F$6;LEN($F$6)-2)&RIGHT($F$6)))

=((ROUND(K23/10;0))*10)*9/100

[ranman256]

Most will be done in a query using the field,

[field]* 45

iif([field]>=9,[field2]/100,0)

*Note: vlookups are not used....you link to the lookup table via matching fields.

[azhar2006]

Thank you very much ranman