excel equation?

Glaucus · 24 Mar 2016 at 17:16

Anyone know how I would do this.
Want to show a minimum value on a result from a sum list. Then when it's reached that point to start adding.

Say if I had say a tow containing 50, 100, 30 that would show as 300 as the sum is below that.

But say it was 50, 100, 30, 520 then the result would show as 700

Confused Stu · 24 Mar 2016 at 17:25

Not really sure what you're, so might have the wrong end of the stick. Do you mean to say "add up this row, if the answer is less than x then write x, if the answer is more than x then write the answer."?

If so, you're looking at something like:

Code:

=IF(SUM(A:A)<300,300,SUM(A:A))

So it's saying add up row A (you could substitute A1:A5 for a batch if needed) and if it's less than 300, put 300. If not, put the sum of row A.

Is that roughly what you're after?

Glaucus · 24 Mar 2016 at 17:32

Thank you, that's exactly what I'm after.

Didn't even think of writing an if statement.

BigT · 24 Mar 2016 at 20:42

I also think this would work:

MAX(SUM(A:A),300)