EXCEL表格中:A1列为发放、领用时,C1列为财务时,D1为0;A1列为发放、领用时,C1列为办公室时,D1数值=B1数值;A1列为收回、作废时,D1数值=-B1数值(例如B1为1则D1为-1);哪位大佬麻烦帮忙看下用什么函数,以及公示怎么弄,谢谢!!!
=IFS(AND(OR(A1={"发放","领用"}),C1="财务"),0,AND(OR(A1={"发放","领用"}),C1="办公室"),B1,OR(A1={"收回","作废"}),-B1)