Possibly

Select the cell then
Data|Validation|Decimal|Less than equal to
enter 10
OK


or if it's a formula then try this in your cell
=MIN(10,your_formula)

Mike

"Emlf25" wrote:

I'm trying to set the maximum value of a cell to 10 but can't seem to get it
right.

Here's my formula so far, any idea's please?

=SUM(B30-140)