有人可以帮我做一个有四个结果的IF声明吗? [英] Can someone help me make an IF statement with four outcomes?
问题描述
我需要制作一个包含四个结果的IF语句。
所选单元格将填入一个数字,然后在另一个名为Risk的表格中查找大范围的数字。
结果应该是低风险,中等风险,高风险和不行。
A3: A2410 =低风险
A2413:A2671 =中等风险
A2675:A2954 =高风险
A2956:A2975 =不去
我尝试了什么:
我自己试过制作IF声明,但是没有运气..
这是我的陈述:
= IF(E3 =风险!A3:A2410,低风险,IF(E3 =风险!A2413:2671) ,中等风险,IF(E3 =风险!A2675:2954,高风险,不行)))
这里有两个问题:
1)您需要通过在前面添加
来指定工作表名称:
。 .. =
风险!...
2)你想要的查看COUNTIF函数以检查值是否在一个范围内: Excel公式:值存在于一个范围内| Exceljet [ ^ ]
I need to make an IF statement with four outcomes.
The selected cell will be filled in with a number and then looked up against a long range of numbers in another sheet called "Risk".
The outcomes should be "Low Risk", "Medium Risk", "High Risk" and "No go".
A3:A2410 = Low Risk
A2413:A2671 = Medium Risk
A2675:A2954 = High Risk
A2956:A2975 = No go
What I have tried:
I have tried making the IF statement myself, but without luck..
Here is my statement:
=IF(E3=Risk!A3:A2410,"Low Risk",IF(E3=Risk!A2413:2671,"Medium Risk", IF(E3=Risk!A2675:2954, "High risk", "No go")))
Two problems here:
1) You need to specify sheet names by prefixing them with "
":
...=
Risk!...
2) You want to look at the COUNTIF function to check if a value is in a range: Excel formula: Value exists in a range | Exceljet[^]
这篇关于有人可以帮我做一个有四个结果的IF声明吗?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!