Maximum value of a cell
 

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)

Maximum value of a cell
 

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)

Maximum value of a cell
 

Please don't multi-post - you have answers elsewhere.

Pete

"Emlf25" wrote in message
...
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)