Validation of a sum
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
|