IF(AND(OR(fieldname5==1,fieldname5==3),fieldname6>0), IF(AND(fieldname6>0,fieldname6<=50000),8000, IF(AND(fieldname6>50000,fieldname6<250000),12000+(fieldname6-50000)*0.10, IF(AND(fieldname6>=250000,fieldname6<1000000),32000+(fieldname6-250000)*0.020, IF(AND(fieldname6>=1000000,fieldname6<5000000),47000+(fieldname6-1000000)*0.015, IF(AND(fieldname6>=5000000,fieldname6<10000000),107000+(fieldname6-5000000)*0.005, IF(AND(fieldname6>=10000000,fieldname6<50000000),132000+(fieldname6-10000000)*0.005, IF(AND(fieldname6>=50000000,fieldname6<100000000),152000+(fieldname6-50000000)*0.0002, "0*") )) )) )) ) /* IF(AND(OR(fieldname4==3000,fieldname4==2400),OR(fieldname5==1,fieldname5==3),fieldname6>0), IF(AND(fieldname4==3000,fieldname6>0,fieldname6<=50000),3000, IF(AND(fieldname4==2400,fieldname6>0,fieldname6<=50000),2400, IF(AND(fieldname4==3000,fieldname6>50000,fieldname6<100000),3000+(fieldname6-50000)*0.058, IF(AND(fieldname4==2400,fieldname6>50000,fieldname6<100000),2400+(fieldname6-50000)*0.0464, IF(AND(fieldname4==3000,fieldname6>=100000,fieldname6<300000),5900+(fieldname6-100000)*0.026, IF(AND(fieldname4==2400,fieldname6>=100000,fieldname6<300000),4720+(fieldname6-100000)*0.0208, IF(AND(fieldname4==3000,fieldname6>=300000,fieldname6<500000),11000+(fieldname6-300000)*0.025, IF(AND(fieldname4==2400,fieldname6>=300000,fieldname6<500000),8880+(fieldname6-300000)*0.020, IF(AND(fieldname4==3000,fieldname6>=500000,fieldname6<1000000),16100+(fieldname6-500000)*0.014, IF(AND(fieldname4==2400,fieldname6>=500000,fieldname6<1000000),12880+(fieldname6-500000)*0.0112, IF(AND(fieldname4==3000,fieldname6>=1000000,fieldname6<2000000),23100+(fieldname6-1000000)*0.005, IF(AND(fieldname4==2400,fieldname6>=1000000,fieldname6<2000000),18480+(fieldname6-1000000)*0.004, IF(AND(fieldname4==3000,fieldname6>=2000000,fieldname6<5000000),28100+(fieldname6-2000000)*0.0049, IF(AND(fieldname4==2400,fieldname6>=2000000,fieldname6<5000000),22480+(fieldname6-2000000)*0.00392, IF(AND(fieldname4==3000,fieldname6>=5000000,fieldname6<10000000),42800+(fieldname6-5000000)*0.0023, IF(AND(fieldname4==2400,fieldname6>=5000000,fieldname6<10000000),34240+(fieldname6-5000000)*0.00184, IF(AND(fieldname4==3000,fieldname6>=10000000,fieldname6<30000000),54300+(fieldname6-10000000)*0.0008, IF(AND(fieldname4==2400,fieldname6>=10000000,fieldname6<30000000),43440+(fieldname6-10000000)*0.00064, IF(AND(fieldname4==3000,fieldname6>=30000000,fieldname6<50000000),70300+(fieldname6-30000000)*0.0007, IF(AND(fieldname4==2400,fieldname6>=30000000,fieldname6<50000000),56240+(fieldname6-30000000)*0.00056, IF(AND(fieldname4==3000,fieldname6>=50000000,fieldname6<100000000),84300+(fieldname6-50000000)*0.0003, IF(AND(fieldname4==2400,fieldname6>=50000000,fieldname6<100000000),67440+(fieldname6-50000000)*0.00024, IF(AND(fieldname4==3000,fieldname6>=100000000,fieldname6<500000000),99300+(fieldname6-100000000)*0.00015, IF(AND(fieldname4==2400,fieldname6>=100000000,fieldname6<500000000),79440+(fieldname6-100000000)*0.00012, IF(AND(fieldname4==3000,fieldname6>=500000000),159300+(fieldname6-500000000)*0.0001, IF(AND(fieldname4==2400,fieldname6>=500000000),127440+(fieldname6-500000000)*0.00008, 0) )) )) )) )) )) )) )) )) )) )) )) )) ) ) */ /*IF(AND(OR(fieldname4==3000,fieldname4==2400),OR(fieldname5==1,fieldname5==3),fieldname6>0), IF(AND(fieldname4==3000,fieldname6>0,fieldname6<=50000),8000, IF(AND(fieldname4==2400,fieldname6>0,fieldname6<=50000),6400, IF(AND(fieldname4==3000,fieldname6>50000,fieldname6<100000),8000+(fieldname6-50000)*0.096, IF(AND(fieldname4==2400,fieldname6>50000,fieldname6<100000),6400+(fieldname6-50000)*0.0768, IF(AND(fieldname4==3000,fieldname6>=100000,fieldname6<300000),12800+(fieldname6-100000)*0.046, IF(AND(fieldname4==2400,fieldname6>=100000,fieldname6<300000),10240+(fieldname6-100000)*0.0368, IF(AND(fieldname4==3000,fieldname6>=300000,fieldname6<500000),22000+(fieldname6-300000)*0.045, IF(AND(fieldname4==2400,fieldname6>=300000,fieldname6<500000),17600+(fieldname6-300000)*0.036, IF(AND(fieldname4==3000,fieldname6>=500000,fieldname6<1000000),31000+(fieldname6-500000)*0.030, IF(AND(fieldname4==2400,fieldname6>=500000,fieldname6<1000000),24800+(fieldname6-500000)*0.024, IF(AND(fieldname4==3000,fieldname6>=1000000,fieldname6<2000000),46000+(fieldname6-1000000)*0.009, IF(AND(fieldname4==2400,fieldname6>=1000000,fieldname6<2000000),36800+(fieldname6-1000000)*0.0072, IF(AND(fieldname4==3000,fieldname6>=2000000,fieldname6<5000000),55000+(fieldname6-2000000)*0.0089, IF(AND(fieldname4==2400,fieldname6>=2000000,fieldname6<5000000),44000+(fieldname6-2000000)*0.00712, IF(AND(fieldname4==3000,fieldname6>=5000000,fieldname6<10000000),81700+(fieldname6-5000000)*0.0045, IF(AND(fieldname4==2400,fieldname6>=5000000,fieldname6<10000000),65360+(fieldname6-5000000)*0.0036, IF(AND(fieldname4==3000,fieldname6>=10000000,fieldname6<30000000),104200+(fieldname6-10000000)*0.0015, IF(AND(fieldname4==2400,fieldname6>=10000000,fieldname6<30000000),83360+(fieldname6-10000000)*0.0012, IF(AND(fieldname4==3000,fieldname6>=30000000,fieldname6<50000000),134200+(fieldname6-30000000)*0.0013, IF(AND(fieldname4==2400,fieldname6>=30000000,fieldname6<50000000),107360+(fieldname6-30000000)*0.00104, IF(AND(fieldname4==3000,fieldname6>=50000000,fieldname6<100000000),160200+(fieldname6-50000000)*0.0006, IF(AND(fieldname4==2400,fieldname6>=50000000,fieldname6<100000000),128160+(fieldname6-50000000)*0.00048, IF(AND(fieldname4==3000,fieldname6>=100000000,fieldname6<500000000),190200+(fieldname6-100000000)*0.00030, IF(AND(fieldname4==2400,fieldname6>=100000000,fieldname6<500000000),152160+(fieldname6-100000000)*0.00024, IF(AND(fieldname4==3000,fieldname6>=500000000),310200+(fieldname6-500000000)*0.0002, IF(AND(fieldname4==2400,fieldname6>=500000000),248160+(fieldname6-500000000)*0.00016, 0) )) )) )) )) )) )) )) )) )) )) )) )) ) )*/

Tarification

Simulateur de coûts

> Barèmes et règles de tarification

Contact

Adresse