How to use conditional statement

**maverick3483** · 05-10-2009, 01:02 PM

Hi,

Please cananyone help me on this issue.

Present I have this. The total column adds up the mark of the student in all the subjects.
Student Sub1 Sub2 Sub3 Sub4 Total
S1 12% 38% 20% 20% 100%
S2 13% 37% 19% 31% 100%
S3 15% 15% 15% 15% 100%

This is what I want. As a user, I can enter only 100 in any one of the subject and this would automatically lock the rest of the cells. I want to do this only for few students and not for all.

Student Sub1 Sub2 Sub3 Sub4 Total
S1 0% 100% 0% 0% 100%
S2 0% 0% 100% 0% 100%
S3 0% 0% 0% 0% 100%

**teylyn** · 05-10-2009, 05:39 PM

Hi,

assuming that your Sub1 to Sub4 is in Column B to column E:

Select Cells B to E in the row that you want to apply the check, then click Data - Validation, select Custom and enter the formula

=SUM($B2:$E2)<=100%

The above formula is for row 2. Click the Error Alert tab to enter a meaningful error message if needed.

You can easily copy the validation to another row by using Paste - Special and tick Validation.

hth

How to use conditional statement

LinkBack

Thread Tools

Rate This Thread

Display

How to use conditional statement

Re: How to use conditional statement

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions