根据其他列的值更新列(Update a column based on the value of other column)
我的Excel表格如下所示。
如果复杂度难度较大,我希望C列的值为2。 如果低于0.5,如果中等则为0.75。
请让我知道是否有任何公式可用,或者我必须为此写一个马可。
My excel sheet looks like below.
I would like place value of 2 in column C if complexity level is Difficult. If low then 0.5 and if medium then 0.75.
Please let me know if there is any formula available or I have to write a marco for the same.
最满意答案
在C2中:
=IFERROR(INDEX({2,0.75,0.5},MATCH(B2,{"Difficult","Medium","Low"},0)),"Not a Choice")IN C2:
=IFERROR(INDEX({2,0.75,0.5},MATCH(B2,{"Difficult","Medium","Low"},0)),"Not a Choice")更多推荐
发布评论