Max Value in a cell

R

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.
 
J

JoeU2004

razlan said:
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.
Click to expand...

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

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
 
R

razlan

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