if的写了一半
=(IF(F12>E12,IF(F12>8000,8000,IF(F12<C12,E12,F12)), )-E12)*0.1
=(CHOOSE(SUMPRODUCT(1*(F12>({1500,2700,3300,8000})))+1,1500,F12,E12,F12,8000)-E12)*0.1
=(CHOOSE(SUMPRODUCT(1*(F12>({1500,2700,3300,8000})))+1,1500,F12,E12,F12,8000)-E12)*0.1
最后一个 , 可以全部使用单元格 |