我需要将以下四个公式编译成一个单元格块。请帮忙!
=IF(SOURCE!C24>=90,"A"," ")
=IF(AND(SOURCE!C24>=80,SOURCE!C24<90),"B"," ")
=IF(AND(SOURCE!C24>=70,SOURCE!C24<80),"C"," ")
=IF(SOURCE!C24<70,"F"," ")
答案1
这应该有效:
=IF(C1>=90, "A", IF(C1>=80,"B", IF(C1>=70, "C", IF(C1>=60, "D", "F"))))
如果需要,您可能需要重新添加工作表引用。为此,只需将所有引用更改C1
为SOURCE!C24
。
答案2
在这种情况下,您可以使用一个LOOKUP
函数-尝试这个:
=LOOKUP(Source!C24,{0,70,80,90},{"F","C","B","A"})
根据第一个数组中每个范围的“下限”查找分数,并从第二个数组中返回相关字母