Видео

=ROUND(IF(AK16<=600000,(AK16*0),IF(AND(AK16>600001,AK16<=1200000),(0+((AK16-600000)*0.05)),IF(AND(AK16>1200001,AK16<=2200000),(30000+((AK16-1200000)*0.15)),IF(AND(AK16>2200001,AK16<=3200000),(180000+((AK16-2200000)*0.25)),IF(AND(AK16>3200001,AK16<=4100000),(430000+((AK16-3200000)*0.3)),IF(AND(AK16>4100001,AK16<=41000001),(700000+((AK16-4100000)*0.35)))))))), 0)