Hello! Please help with the implementation of automated scoring of people.
The table records the answers to the tests.
These people's answers consist of two numbers.
If the person's answer is absolutely true (both are true), then next to that user to give a mark - 3. If one of those two numbers is true, then supply - 2 points, if the first number is greater than the second - 1 point, and if nothing is wrong - 0 points. Should check several conditions.
I'll try to describe the problem more differently:The first condition:
, then in the cell to record a - 3
;The second condition:
If X - Y = X1 - Y1
, in the cell record - 2
;The third condition:
If X > Y = X1 > Y1
, the cell write 1
If all three conditions are not met, then the cell record 0
Yet been able to implement such a formula to a cell:
Ie, the formula checks the specified correct answers, and puts the 3 ball, or 0 if not the same. But she says the 3 ball, even if the number of cell C3
will be the same as the D4
, which should not be.. are unable to realize full expression to check for all 4 conditions..
Help please, who knows. You can thank the beer or juice))