Help with "IF" formula please

[Aqua1967]

I have 4 numbers to sum (B5:B8). Cell B9 contains the formula to sum those cells. I need the sum to indicate 0 if the sum total is a negative number. If the sum total is greater than 250000, I need the total to indicate 250000.

I've been able to figure out how to get it to return a number no greater than 250000, but have been unable to figure out how to also incorporate the formula to include returning 0 if the sum is a negative number.

This is the formula I have so far: =IF(SUM(B5:B8)>=250000,250000SUM(B5:B8))

Can someone help me add the other part to this formula?

Thank you so much!

 

[Joe4]

Try:

=MIN(MAX(SUM(B5:B8),0),250000)

 

[Aqua1967]

I think this works! It gives me a dash instead of 0, but I think I can live with that.

I was on the wrong track with the IF formula then. Thank you for your help with this!!!

 

[Joe4]

You are welcome!

I think this works! It gives me a dash instead of 0, but I think I can live with that.

That has nothing to do with the formula. That is your cell format. Take a look at what you have it set to, and change it as needed.

I was on the wrong track with the IF formula then.

It can be done with an IF formula, but it is a lot easier to use the MIN/MAX formulas.