求助能看懂Excel公式的爱好者给解释一下公式:此公式:、工龄满一年(次月生成50元)=IF(ISERROR(IF(F19=0,"0",INT((F19-1)/12)*50)),"",IF(F19=0,"0",INT((F19-1)/12)*50))根据公式推算:也就是在第13个月:(13-1)/1
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/11 18:26:14
![求助能看懂Excel公式的爱好者给解释一下公式:此公式:、工龄满一年(次月生成50元)=IF(ISERROR(IF(F19=0,](/uploads/image/z/3247496-8-6.jpg?t=%E6%B1%82%E5%8A%A9%E8%83%BD%E7%9C%8B%E6%87%82Excel%E5%85%AC%E5%BC%8F%E7%9A%84%E7%88%B1%E5%A5%BD%E8%80%85%E7%BB%99%E8%A7%A3%E9%87%8A%E4%B8%80%E4%B8%8B%E5%85%AC%E5%BC%8F%3A%E6%AD%A4%E5%85%AC%E5%BC%8F%EF%BC%9A%E3%80%81%E5%B7%A5%E9%BE%84%E6%BB%A1%E4%B8%80%E5%B9%B4%EF%BC%88%E6%AC%A1%E6%9C%88%E7%94%9F%E6%88%9050%E5%85%83%EF%BC%89%3DIF%28ISERROR%28IF%28F19%3D0%2C%220%22%2CINT%28%28F19-1%29%2F12%29%2A50%29%29%2C%22%22%2CIF%28F19%3D0%2C%220%22%2CINT%28%28F19-1%29%2F12%29%2A50%29%29%E6%A0%B9%E6%8D%AE%E5%85%AC%E5%BC%8F%E6%8E%A8%E7%AE%97%EF%BC%9A%E4%B9%9F%E5%B0%B1%E6%98%AF%E5%9C%A8%E7%AC%AC13%E4%B8%AA%E6%9C%88%EF%BC%9A%2813-1%29%2F1)
xRN@V-#i|&qgэ#"`%%CBKqe/8ݹsϜ{( đh'xhgwhP $:>퇻qZ
,=&қzz(!;hYeWv*K(2Hl(G0X HGMI /E+K