Original poster missed everything 100 & < 101. Just giving the customers
what they ask for

"John C. Harris, MPA" wrote:

Duke...if you just say 101 you miss the number 101

--
John C. Harris, MPA
JCZ Consulting Services, LLC
"audi" wrote in message
...
if sum of total is 101 or must multiply that cell by 4

if sum of total is 100 or , than automatically put a 0 to cell