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


Read responses in techsupportforum.com

Last videos:

Steelseries Rival 600
Steelseries Rival 600
Replacing Nvidia 980M with GTX 1070
Replacing Nvidia 980M with GTX 1070
Instrumental request :)
Instrumental request :)
Intel Optane 900d
Intel Optane 900d
Old Machine Mod
Old Machine Mod
Occasional problem with YouTube on desktop Windows
Occasional problem with YouTube on desktop Windows
Pump Resivour
Pump Resivour
Life Videos Youtube
Life Videos Youtube
Cars · 
Mobility · 
Hardware · 
Motorbikes · 
Travel · 
Boating · 
Aviation · 
production-frontend
About Forumsee · Contact · Privacy policy · Request content removal
We use cookies for navigation analysis and personalized advertisement. By using our site, you agree to our use of cookies.
Accept  ·  Learn more