maximum value of a cell

[Emlf25]

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)

 

[FSt1]

hi
....uh...how would a formula limit the value???
use data validation.
on the menu bar....
data>validation
in the settings tab...
set to whole number or decimal
less than or equal to
10
on the message tab...
allert!
Enter a value 10 or less
on the error tab....
IDIOT!!!!!
the value excedes 10. try again.

regards
FSt1

 

[Pete_UK]

Maybe:

=MAX(10,B30-140)

Hope this helps.

Pete

hi
...uh...how would a formula limit the value???
use data validation.
on the menu bar....
data>validation
in the settings tab...
set to whole number or decimal
less than or equal to
10
on the message tab...
allert!
Enter a value 10 or less
on the error tab....
IDIOT!!!!!
the value excedes 10. try again.

regards
FSt1







- Show quoted text -

 

[David Biddulph]

MIN, rather than MAX, Pete?
--
David Biddulph

Maybe:

=MAX(10,B30-140)

Hope this helps.

Pete

 

[Pete_UK]

Yeah, you're right, David, though it was a complete guess what the OP
wanted as it didn't make any sense to me.

Pete