想請教樓主, 想整個excel表入信用卡交易記錄
A-B行講去邊間商戶買野有多D回贈
D-E行入交易記錄, F行就跟據A-B行自動搵回贈比例幾多
但MCDONALD有好多分店, 交易記錄個名都唔同,
平時用vlookup可以簡寫搵全寫, 掉轉就唔識
=LET(income,B1,allowance,B2,deductions,B3,netincome,income-deductions,netchargeableincome,income-allowance-deductions,standardtax,IF(netincome>5000000,5000000*0.15+(netincome-5000000)*0.16,netincome*0.15),progressivetax,IF(netchargeableincome<=45000,netchargeableincome*0.02,IF(netchargeableincome<=90000,900+(netchargeableincome-45000)*0.07,IF(netchargeableincome<=135000,4050+(netchargeableincome-90000)*0.12,9450+(netchargeableincome-135000)*0.17))),MIN(progressivetax,standardtax))