Validation rules base on formula on other cell

S

Souris

I have a student grade calculation sheet.
I give user to change the ratio of exam and home work.
For example: Midterm : 30%, Final: 50%, Home Work:15%.

I would like to validate the total ratio should not more than one hundred
percent.

My problem is when I set the total ratio cell validation rule does not over
100% which only works when I manual enter a value more than one hundred
percent

For example user enter Midterm : 50%, Final: 50%, Home Work:15%.
The validation rule does not triggle


If user enter the value on home work and exam more that 100% the validation
rule does not triggle.

Are there any solution for this?

Thanks in advance,
 

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.

Ask a Question

Similar Threads

Validation Rules for a Control on a Form (?) 4
VBA for data validation in 3rd column does not run. I need help. 1
Custom validation rule - must be 15 increment of time 1
Data Validation blanks for formulas 18
Custom Validation formula for business rules 3
Validate Cell Value 11
Need Help w/InfoPath Browser Form Validation Rule 3
Help? SUM row to a cell with a specific value in a different row 4

Top