Excel 表格计算个调税公式

引用:

Originally posted by 尤宝宝妈妈 at 2005/6/2 16:21:
=IF(L4="","",IF(L4-1000>60000,(L4-1000)*35%-6375,IF(L4-1000>40000,(L4-1000)*30%-3375,IF(L4-1000>20000,(L4-1000)*25%-1375,IF(L4-1000>5000,(L4-1000)*20%-375,IF(L4-1000 ...