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.
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.
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
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.