I NEED TO FIND TWO FORMULAS
 

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

=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

=4*cell*(total101)

"audi" wrote:

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

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

"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

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

One more try -

John, I agree with your point. Mea culpa

"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

Oh I know its what he asked for. been around this too long I guess. Need to
read people's minds in this line of work. LOL

--
John C. Harris, MPA
JCZ Consulting Services, LLC

"Duke Carey" wrote in message
...
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