excel if问题

0-3 *154-7 *208-15 *2215以上 *2+330
2025-12-16 19:10:37
推荐回答(1个)
回答1:

假如单元格为A1
=if(A1>15,A1*2+330,IF(A1>=8,A1*22,IF(A1>=4,A1*20,IF(A1>=0,A1*15,"您的输入有误"))))