作者:乔山办公网日期:
返回目录:excel表格制作
=IF(AND(G6>=40000,H6>=8,I6>=1000),"卓越抄",IF(AND(G6>=25000,H6>=5,I6>=1000),"优秀",IF(AND(G6>=15000,H6>=3,I6>=1000),"标准"," ")))
这个袭主管千P我都用百的1000,你度没写清楚问,可以自己答修改
=25000,H6>=5,I6>=1000),"优秀",IF(AND(G6>=15000,H6>=3,I6>=1000),"标准"," ")))这个袭主管千P我都用百的1000,你度没写清楚问,可以自" />