excel中当某一格等于数值时显示文字 当A1等于1,2时,B1显示“木”;当A...答:B1单元格写入公式 =IF(A1="","",IF(OR(A1={1,2}),"木",IF(OR(A1={3,4}),"火",IF(OR(A1={5,6}),"土",IF(OR(A1={7,8}),"金",IF(OR(A1={9,0}),"水","")))或 =IF(A1="","",CHOOSE(A1+1,"水","木","木","火","火","土","土","金","金","水...
excel表格中怎么让A1大于或者小于等于某个值,B2中数据根据A1判定让C1...答:最好上图说明 我猜测你要的公式是不是这样的 C1单元格写入公式 =IF(A1="","",IF(A1<1982,B1,IF(A1<1987,200,"")))按你的图 E3单元格写入公式 =IF(C3="","",IF(C3<1982,D3,IF(C3<1987,200,"")))下拉填充公式 没有说明大于等于1987年时应返回的值,让其返回空值了 ...