Checking whether each of the values in List1 (column C) meets the following criteria:
1. The number must be even.
2. The number must be smaller than 3 or larger than 8.
Combining the AND and OR functions in the following IF statement:
Although the IF is not needed here, since the AND and OR functions return TRUE and FALSE depending on the criteria.
Last edited by Paul; 02-15-2012 at 04:59 AM.
Reason: Formula was missing the latter half due to forum formatting issues.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1