答案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)
用您定义的公式替换<>。