=IF(A4=101, A4*4, 0)

Replacing A4 with the Cell that is the Sum

--
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