A
audi
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 sum of total is 100 or , than automatically put a 0 to cell
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
John C. Harris, MPA
=IF(A4>=101, A4*4, 0)
Replacing A4 with the Cell that is the Sum
Replacing A4 with the Cell that is the Sum
D
Duke Carey
=4*cell*(total>101)
J
John C. Harris, MPA
Duke...if you just say >101 you miss the number 101
D
Duke Carey
John C. Harris said:Duke...if you just say >101 you miss the number 101
D
Duke Carey
Original poster missed everything >100 & < 101. Just giving the customers
what they ask for
what they ask for
D
Duke Carey
One more try -
John, I agree with your point. Mea culpa
John, I agree with your point. Mea culpa
J
John C. Harris, MPA
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
read people's minds in this line of work. LOL