I NEED TO FIND TWO FORMULAS

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Original poster missed everything >100 & < 101. Just giving the customers
what they ask for
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculation of weighed average 6
Rounding Question 9
Excel Formula or equation 3
Summing a range of cells based on criteria in another range 2
Create a complex formula 1
formula in excel 2
Finding and copying whole rows 1
Excel formula, sum the value cell and if empty cell left blank 0

Back
Top