Validation of a sum
The solution is even more simple. Once again we want the sum of cells A1
thru A20 to be 100. We allow the user to fill only cells 1 thru A19. In
cell A20 we enter:
=100-SUM(A1:A19) and protect this cell. This will absolutely force the
condition to be true!!
--
Gary''s Student - gsnu200755
"Jane" wrote:
Thanks - but I know that formula.
I look for a solution, where the sum is being validated in a way, that make
it impossibly to move to the next step until the rule is satisfied.
--
Jane
"Gary''s Student" skrev:
Let's say the cells in question are A1 thru A20. In another cell enter:
=IF(OR(SUM(A1:A20)=0,SUM(A1:A20)=100),"Valid","Not Valid")
--
Gary''s Student - gsnu200755
"Jane" wrote:
I want to validate that a sum of cells is 0 or 100. How do I do that?
--
Jane
|