这道excel题目怎么做

这道excel题目怎么做

D2公式下拉：
=IF(C2="男",IF(C2>=90,"优秀",IF(C2>=80,"良好",IF(C2>=70,"中等",IF(C2>=60,"及格","不及格")))),IF(C2>=85,"优秀",IF(C2>=75,"良好",IF(C2>=65,"中等",IF(C2>=60,"及格","不及格")))))
公式下拉方法：
选中要下拉的单元格，鼠标移到该单元格右下方，鼠标指针变为黑色的实心加号 + ，然后按住左键不放，向下拉即可。

自己百度‘Excel if函数用法’花5分钟就能学会，有必要这么简单还要来问吗，求人不如求己，也希望你以后上课时候能听讲。

D2输入=if(B2="男"，lookup(C2,{0,60,70,80,90},{"不及格","及格","中等","良好","优秀"}，lookup(C2,{0,60,65,75,85},{"不及格","及格","中等","良好","优秀"})，公式向下粘贴

这样的题目你必须要多加练习，操作上还是简单的，只是需要多做多熟练吧
在D2单元格输入公式：
=IF(B2="男",IF(C2<60,"不及格",IF(C2<70,"及格",IF(C2<80,"中等",IF(C2<90,"良好","优秀")))),IF(C2<60,"不及格",IF(C2<65,"及格",IF(C2<75,"中等",IF(C2<85,"良好","优秀")))))
复制并下拉，即可

在D2中输入或复制粘贴下列公式
=IF(B2="男",LOOKUP(C2,{0,60,70,80,90},{"不及格","及格","中等","良好","优秀"}),LOOKUP(C2,{0,60,65,75,85},{"不及格","及格","中等","良好","优秀"}))
或
=IF(B2="女",LOOKUP(C2,{0,60,65,75,85},{"不及格","及格","中等","良好","优秀"}),LOOKUP(C2,{0,60,70,80,90},{"不及格","及格","中等","良好","优秀"}))
或
=IF(B2="男",VLOOKUP(C2,{0,"不及格";60,"及格";70,"中等";80,"良好";90,"优秀"},2),VLOOKUP(C2,{0,"不及格";60,"及格";65,"中等";75,"良好";85,"优秀"},2))
或
=IF(B2="女",VLOOKUP(C2,{0,"不及格";60,"及格";65,"中等";75,"良好";85,"优秀"},2),VLOOKUP(C2,{0,"不及格";60,"及格";70,"中等";80,"良好";90,"优秀"},2))
下拉填充

D2用公式：
=LOOKUP(C2,IF(B2="男",{0,60,70,80,90},{0,60,65,75,85}),{"不及格","及格","中等","良好","优秀"})
下拉。