![具有两个逻辑测试的 IF 函数](https://linux22.com/image/1572753/%E5%85%B7%E6%9C%89%E4%B8%A4%E4%B8%AA%E9%80%BB%E8%BE%91%E6%B5%8B%E8%AF%95%E7%9A%84%20IF%20%E5%87%BD%E6%95%B0.png)
答案1
=(if(e6=s6,<AnnualSalary/totalDaysInYear*NumberofDaysinMonth>,if(e6=H6,<AnnualSalary*H6>,"notEqualtoEitherS or H column"))*(if(M6="6%",1.06,1)
用您定义的公式替换<>。
=(if(e6=s6,<AnnualSalary/totalDaysInYear*NumberofDaysinMonth>,if(e6=H6,<AnnualSalary*H6>,"notEqualtoEitherS or H column"))*(if(M6="6%",1.06,1)
用您定义的公式替换<>。