"IF" Function Help ?

[MAX258]

Good Morning. I think this is "IF" function help, but can't be sure.

Here's what I am trying to do. I have a cell with a number in it, say 57. In another cell I want to return the value of 50 only, in other words delete anything over 50. I currently have this:

Cell A1 = 50

=IF(A1>50,"50",A1)

This ends up returning the actual value if it's less than 50 (which I want)....and ends up returning "50" to the cell if it's over 50, except that it's not a value of 50 - if I have a 50, 50, and 45 it sums the 3 cells as only 45.

Thanks in advance for the help.
Max

[MAX258]

Thanks everybody, I have found the answer.


Remove the " " from the 50.

[Cutter]

Another way is:
=MIN(A1,50)