如何将这三个公式组合在一起?
=IF(F39<=20000;(F39)*0.1)
=IF(AND(20000<F39;F39<=50000);(F39)*0.15)
=IF(F39>50000;(F39)*0.2)
Try,
=f39*(0.1+(f39>20000)*0.05+(f39>50000)*0.05)