當(dāng)前位置:財(cái)稅問(wèn)題 >
實(shí)務(wù)
問(wèn)題已解決
Excel這個(gè)if函數(shù)怎么設(shè),小于等于60為A,大于60小于等于90為B,大于90小于等于120為C,大于120為D



你好!F6為目標(biāo)單元格
=IF(F6<=60,"A",IF(AND(F6>60,F6<=90),"B",IF(AND(F6>90,F6<=120),"D")))
2018 04/27 12:50
