EXCEL怎么用函数查找同时满足两个条件的值

2025-02-28 19:26:05
推荐回答(2个)
回答1:

if和and
如条件a,条件b
满足时取值x,不满足时取值y
如=if(and(A1=a,B1=b),"x","y")

回答2: