excel中三个单元格同时满足条件则等于另一值求改错,急=IF(AND(G2≥50%,I2≥6000,J2≥6000),"D*100",IF(AND(G2≥40%,I2≥4500,J2≥4500),"D*70",IF(AND(G2≥30%,I2≥3000,J2≥3000),"D*50","")))当三个单元格同时满足条件G2

Question

excel中三个单元格同时满足条件则等于另一值求改错,急
=IF(AND(G2≥50%,I2≥6000,J2≥6000),"D*100",IF(AND(G2≥40%,I2≥4500,J2≥4500),"D*70",IF(AND(G2≥30%,I2≥3000,J2≥3000),"D*50","")))
当三个单元格同时满足条件G2≥50%,I2≥6000,J2≥6000时当前单元格等于D*100,以此类推,怎么写都不对求改错.万谢!

Answer 1

这里的D是什么,是引用的单元格的话,要具体到是哪个单元格,D2还是D几,同时把公式里的双引号去掉.
还有要用>=,不能用≥.