Thread: Validation of a sum
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
  
Posts: 2,480
Default Validation of a sum
Hi Jane

One way
=IF(OR(ROUND(SUM(D1:D10),0)=0,ROUND(SUM(D1:D10),0) =100),"OK","Wrong")

--
Regards
Roger Govier



"Jane" wrote in message
...
I want to validate that a sum of cells is 0 or 100. How do I do that?
--
Jane


Reply With QuoteReply With Quote