Max Value in a cell

[razlan]

I want the value of a sum of few cellls to not exceed 50. Example ; Sum
(A1:E1) will show in F1 cell the value of 56. Can I make F1 cell shows
the value of 50 instead of 56. Tq for ur kind help.

 

[JoeU2004]

I want the value of a sum of few cellls to not exceed 50.
Example ; Sum (A1:E1) will show in F1 cell the value of 56.
Can I make F1 cell shows the value of 50 instead of 56.

=MIN(50, SUM(A1:E1))

 

[Bernard Liengme]

=MIN(SUM(A1:E1),50)
will return the Sum's value until it exceeds 50 and then it will return 50
best wishes

 

[razlan]

Thank you, JoeU2004 and Bernard.
The formula given by u works fine with me.
Warmest regards.