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
 

hi
....uh...how would a formula limit the value???
use data validation.
on the menu bar....
datavalidation
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
"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
 

Maybe:

=MAX(10,B30-140)

Hope this helps.

Pete

On Mar 3, 2:19*pm, FSt1 wrote:
hi
...uh...how would a formula limit the value???
use data validation.
on the menu bar....
datavalidation
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



"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)- Hide quoted text -

- Show quoted text -

maximum value of a cell
 

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

"Pete_UK" wrote in message
...
Maybe:

=MAX(10,B30-140)

Hope this helps.

Pete

On Mar 3, 2:19 pm, FSt1 wrote:
hi
...uh...how would a formula limit the value???
use data validation.
on the menu bar....
datavalidation
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



"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)- Hide quoted text -

- Show quoted text -

maximum value of a cell
 

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

On Mar 3, 7:28*pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
MIN, rather than MAX, Pete?
--
David Biddulph

"Pete_UK" wrote in message

...
Maybe:

=MAX(10,B30-140)

Hope this helps.

Pete

On Mar 3, 2:19 pm, FSt1 wrote:



hi
...uh...how would a formula limit the value???
use data validation.
on the menu bar....
datavalidation
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

"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)- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -