EXCEL中如何用IF函数实现通过两个独立条件,返回五种值?答:只用IF也有很多总方法,下面为其中一种。E3 =IF(C3="男","父",IF(C3="女","母","未知"))&IF(C3="未知","",IF(D3="男","子",IF(D3="女","女","未知")))下拉复制。也可以通过判断C3&D3=“男男”或者 “男女”这样进行判断。
EXCEL IF函数 A数值等于3个数,则B等于某一个数值.答:=IF(OR(A1={1,2,3}),"1Q",IF(OR(A1={4,5,6}),"2Q",IF(OR(A1={7,8,9}),"3Q",IF(OR(A1={10,11,12}),"4Q","")))这样就可以了