我正在尝试将结果显示为"0"，以表示不会给功劳 [英] I am trying to get a result to display '0' to show no credit will be given

问题描述

我的名字叫罗伯特(Robert)，我是一名中学数学老师.以下公式对我有用，但对于不满足全部或部分信用标准的响应，我还需要将其赋值为零.您能提供的任何帮助将不胜感激.

My name is Robert, and I am an intermediate school math teacher. The following formula works for me, but I also need to a assign a value of zero for a response not meeting the full or partial credit criteria. Any assistance you can provide will be greatly appreciated.

= IF(B1 ="，"，IF(AND(ISNUMBER(SEARCH("minimum"，B1))，ISNUMBER(SEARCH("maximum"，B1))，ISNUMBER(SEARCH("range"， B1))，NOT(ISNUMBER(SEARCH({"mean"，"median"，平均绝对偏差"，四分位数间距"}，B1)))))，2,1))

=IF(B1="","",IF(AND(ISNUMBER(SEARCH("minimum",B1)),ISNUMBER(SEARCH("maximum",B1)),ISNUMBER(SEARCH("range",B1)),NOT(ISNUMBER(SEARCH({"mean","median","mean absolute deviation","interquartile range"},B1)))),2,1))

学生回应:

最小值极有可能保持不变，因为除非命中小于10，否则不应更改.与最大值相同.除非他的命中率高于50，否则它也不应该改变.因为添加了新的数字，所有其他情况都会发生变化.均值会发生变化.中位数也会发生变化.平均绝对偏差将改变.那将会改变.最后，平等也将改变.

The minimum would most likely stay the same because unless the hit was less than 10 then it shouldnt change. Its the same with the maximum. Unless his hit is higher than 50 then it shouldnt change either. All of the other things would change because a new number was added in. The mean would change.The median would change. The mean absolute deviation would change. The would change. And finally, the interequality would change as well.

(完整信用):

如果一个单元格包含最小"，最大"和范围"以及除平均"，中位数"，平均绝对偏差"或四分位数范围"以外的其他任何单词，我要分配结果的值为"2".

If a cell contains "minimum", "maximum", and "range" with any other words EXCLUDING "mean", "median", "mean absolute deviation", or "interquartile range", I want to assign the result to a value of '2'.

(部分信用):

如果一个单元格包含最小值"，最大值"和范围"以及其他任何单词，包括平均值"，中位数"，平均值绝对偏差"或四分位间距"，我想将结果分配给值为"1".

If a cell contains "minimum", "maximum", and range" with any other words INCLUDING "mean", "median", "mean absolute deviation", or "interquartile range", I want to assign the result to a value of '1'.

(零信用):

如果一个单元格不包含最小"，最大"和范围"以及平均"，中位数"，平均绝对偏差"或四分位数间距"以外的其他任何单词，我要分配结果为"0".

If a cell DOES NOT contain "minimum", "maximum", and "range" with any other words EXCLUDING "mean", "median", "mean absolute deviation", or "interquartile range", I want to assign the result to a value of '0'.

或

如果一个单元格不包含最小值"，最大值"和范围"以及其他任何单词，包括平均值"，中位数"，平均值绝对偏差"或四分位数间距"，我要分配结果为"0".

If a cell DOES NOT contain "minimum", "maximum", and "range" with any other words INCLUDING "mean", "median", "mean absolute deviation", or "interquartile range", I want to assign the result to a value of '0'.

推荐答案

使用此线程-对于字符串中的某些单词，使用true/false具有类似的功能. 有没有办法在单元格中搜索特定的单词-不管顺序如何?

use this thread - it has something similar using true/false for certain words in a string. Is there a way to search a cell for specific words--regardless of order?

这篇关于我正在尝试将结果显示为"0"，以表示不会给功劳的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！