Setting Restrictions On Cell Values

Can you please post a sample sheet showing expected results.

Yes they are always whole numbers. The rules need to be set up together for the same column.

My interpretation was that if 10 numbers are entered in a range that one cell (undefined) must be <9 and similarly for > 11 (???) So the 15 would apply to all cells but rules 2 & 3 have to be "evaluated".

Here is what I have so far. I have set the maximum rule up but nothing else.

Originally Posted by JohnTopley

My interpretation was that if 10 numbers are entered in a range that one cell (undefined) must be <9 and similarly for > 11 (???) So the 15 would apply to all cells but rules 2 & 3 have to be "evaluated".

That's correct John.

Originally Posted by Fotis1991

Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore requests by Administrators, Moderators and senior forum members regarding forum rules.

If you are unclear about the request or instruction then send a private message to them asking for clarification.

All participants:
Please do not post a reply in a thread where a moderator OR a Senior Member(post#5)has requested an action that has not yet been complied with e.g Title change or Code tags...etc. Thanks.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

I've changed it. Is it still not acceptable?

Now that the moderation request is fulfilled,

Try the following formula in "Data Validation"

=AND(MIN($B$2:$B$6)<9,MAX($B$2:$B$6)>11,AND($B$2<=15,$B$3<=15,$B$4<=15,$B$5<=15,$B$6<=15))

Originally Posted by cbatrody

Now that the moderation request is fulfilled,

Try the following formula in "Data Validation"

=AND(MIN($B$2:$B$6)<9,MAX($B$2:$B$6)>11,AND($B$2<=15,$B$3<=15,$B$4<=15,$B$5<=15,$B$6<=15))

That's fantastic! Thank you for the help. Sorry for any inconvenience caused with the title, I don't go on forums very much.

You are welcome

If that takes care of your question, please mark this thread as Solved by selecting Thread Tools --> Mark thread as solved.

Also, you can directly thank those who have helped you by clicking on the small * (star) icon located in the lower left corner of a post that you have found to be helpful.

Originally Posted by cbatrody

You are welcome

If that takes care of your question, please mark this thread as Solved by selecting Thread Tools --> Mark thread as solved.

Also, you can directly thank those who have helped you by clicking on the small * (star) icon located in the lower left corner of a post that you have found to be helpful.

Will do. I think I did that with your post already.

I tried this and I could only enter a minimum value of 12 in cell A2: is this correct?

Originally Posted by JohnTopley

I tried this and I could only enter a minimum value of 12 in cell A2: is this correct?

Yes I noticed that. I don't know if there is anyway around that. I will just have to inform the students that they must award a score of +11 first.

Originally Posted by JohnTopley

I tried this and I could only enter a minimum value of 12 in cell A2: is this correct?

Did you see the attachment I posted in #11? You need to clear the cells (B2:B6) first before entering the new set of numbers.