AnsweredAssumed Answered

If statement? AND/OR

Question asked by karaharmet on Jul 13, 2017
Latest reply on Jul 14, 2017 by karaharmet

I want to write an if statement that determines whether a scale is calibrated properly. I have been trying different 'if statements' and none of them seem to be working in excel. The if statement in English: If any of the 4 corners have a difference of 0.2 compared to the center, the scale needs to be re-calibrated. I have attached what I have been working with so far. Lines 184-203 are the relevant lines to this situation. I am having trouble with the syntax. If someone could show me how the structure of an If/OR statement works in excel or an If/AND statement it would be greatly appreciated. I can't seem to find a concrete example online. I get a validation error whenever I try to run the survey.

Outcomes