关于EXCEL中if 函数多重嵌套的问题

=IF(D5<25,"不及格",IF(D5<=29),"及格",IF(D5<=39,"中",IF(D5<=59,"良","优"))))
或者:
=IF(D5>=60,"优秀",IF(D5>=40,"良",IF(D5>=30,"中",IF(D5>=25,"及格","不及格"))))

声明：你问我答网所有作品（图文、音视频）均由用户自行上传分享，仅供网友学习交流。若您的权利被侵害，请联系fangmu6661024@163.com

04-15 419阅读

04-15 226阅读

04-15 59阅读