=IF(H5>=90,"a",IF(H5>=85,"b",IF(H5<85,"c")))
=IF(H5>=90,"a",IF(H5<90,"b",IF(H5<85,"c")))
我感觉这两组数据是一个意思 但为什么第二组数据是错误的呢 第二组数据确定后 70竟然为b 而第一组数据设定后 一切显示正常
=IF(H3>=85,"优",IF(H3<60,"不及格",IF(H3<70,"及格",IF(H3<85,"良"))))
=IF(H3>=85,"优",IF(H3<60,"不及格",IF(H3<85,"良",IF(H3<70,"及格"))))这两组数据 只是后面两部分的顺序颠倒 但结果也不一样 第二组是错误的 第一组显示正常