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!
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!
Last edited: