MAX function based on value other cell

[marcusz]

Hi,

I am struggling for a while to get this working.
I have 2 cells that I SUM, but the value cant be greater then cell A3.
So I try>
=MAX(A3,(SUM(E3:D3)))
but I cannot get it to work.
Am I making some stupid syntax error ?

Thanks in advance

 

[jasonb75]

You need MIN not MAX (you would only use MAX for this if your values were negative).

 

[marcusz]

You need MIN not MAX (you would only use MAX for this if your values were negative).

tried this
=MIN,(A3,(SUM(D3:E3))

doesnt work, seems like syntax error maybe ?

 

[mikerickson]

What do you mean "doesn't work"? Does it return the wrong value or something else?
Could you give us an example of the data in the cells, the result that formula returns and what you want it to return?

 

[jasonb75]

Too many commas and parentheses

=MIN(A3,SUM(D3:E3))

 

[marcusz]

even when I use that the 2 ( ) around D3:E3
are in red
using excel 2016

screenshot attached of error when trying to enter formula

thanks in advance for your help

 

[jasonb75]

You have Euro regional settings so you need to change the commas to semicolons.

=MIN(A3;SUM(D3:E3))

You may also need to translate MIN and SUM into your own language (Dutch?).

 

[marcusz]

Hi Jason, I am Dutch ,but my machine settings etc are English International
So this does works for me :

=MIN(A3;SUM(D3;E3))

thanks a lot for your support, much appreciated !