問題:計算優(yōu)惠后金額

每滿300減40,不滿300部分,每滿100減10

邏輯:先計算滿300的優(yōu)惠,在算300取余后的滿100優(yōu)惠

=A2-INT(A2/300)*40-INT((MOD(A2,300)/100))*10