Forumsee logo
Forumsee » Hardware » Networking » Read message
RSS: Subscribe to RSS

MULTIPLE DATA VALIDATION RULES IN...

General Computer Security - Tech Support Forum - www.techsupportforum.com
Hi

I am trying to write a formula in Excel data validation that meets one or the other condition.

I tried the following, but it does not trigger the validation pop-up box.

The formula is as follows:

=OR(SUM($E$11)<=8,SUM($E$11)<4)

i HAVE UNCHECKED "IGNORE BLANKS"

Hope I have been clear.

Jean
Date: Oct 10, 2017   


Last videos:

Is Dolby Vision More Important Than Bit Rate?
Is Dolby Vision More Important Than Bit Rate?
How do I Create an Intranet Based on a Youtube Video.
How do I Create an Intranet Based on a Youtube Video.
Google Assistant is out for Shield NOW, Sony TVs to follow!
Google Assistant is out for Shield NOW, Sony TVs to follow!
Hide any folder from computer without software
Hide any folder from computer without software
i5-6600k, GTX 1060 6g random...
i5-6600k, GTX 1060 6g random...
i5-6600k, GTX 1060 6g random...
i5-6600k, GTX 1060 6g random...
i5-6600k, GTX 1060 6g random...
i5-6600k, GTX 1060 6g random...
Hauppauge HD PVR 2 video blurry...
Hauppauge HD PVR 2 video blurry...

Cars ·
Travel ·
Pets ·
production-frontend