请教下,excel的条件判断如何写?
当A2不为空时,B2就等于B1+1,否则就为空;
当sheet1表的A1不为空时,sheet2表的A1就等于Sheet!A1,否则就为空;
B2=if(A2="",B1+1,"")
sheet2表的A1=if(sheet1!A1<>"",sheet1!A1,"")
下一篇:谁能解释一下薪资
热门标签:
当A2不为空时,B2就等于B1+1,否则就为空;
当sheet1表的A1不为空时,sheet2表的A1就等于Sheet!A1,否则就为空;
B2=if(A2="",B1+1,"")
sheet2表的A1=if(sheet1!A1<>"",sheet1!A1,"")
下一篇:谁能解释一下薪资