Well. The quest to build an extreme IF starts now.

If you want to try and achieve this goal you will need to build 3 functions first. One for Each Test described and after we will combine it into 1 Massive IF!

Let's go with the first test! Country Testing

IF it's not from Canada AND not from the US AND not from Mexico THEN It's "INVALID" OR ELSE it's "Still unsure"

To try it out, put this function in cell J2 and populate it down:

=IF(AND(E2<>"Canada",E2<>"US",E2<>"Mexico"),"INVALID","Still Unsure")

The second test - Date Testing

We will run a new IF with an OR to check if the date is before the 15th and after the 25th of April 2020. If it is the case they receive the VALID label or else it's Still unsure

The serial number for these dates are (43936 & 43946 respectfully)

To try it out, put this function in cell K2 and populate it down:

=IF(OR(B2<43936,B2>43946),"VALID","Still Unsure")

You could read this function as :

IF the date is before the 15th OR the date is after the 25th THEN it's VALID OR ELSE it's still unsure

The third test - Double TRUE

The goal of this test is to make sure that the both the cell in collumn C and collumn D are populated and if they are, they receive the VALID label and if they aren't they are considered INVALID

Here it is :

=IF(AND(C2=TRUE,D2=TRUE),"VALID","Still Unsure")

Once you have all 3 collumns you can now start thinking of how combining them together. What will be required is some skillfull copying and pasting!

Here is how you can do it in Excel:

First you will go take the function in the K2 cell and select everything except the = and hit CTRL-C to copy it and hit ESCAPE to leave the formula. Go paste it where it says "still unsure" in the IF statement in J2 (because since it's still unsure you add a level of certainty by putting the IF in it)

Look at this gif to get a better idea

	1.1	My first Excel Tracker
	1.2	Excel Report Printing
	1.3	Excel Home Budget
	2.1	Clean up this Excel Data
	2.2	Manage this Excel Data
	2.3	Check the results for this survey
	2.4	Analyse this Excel Data
	2.5	Make a PivotTable Copy of a Table
	2.6	Build an Excel AdHoc Report
	3.1	Learning IF's in Excel
	3.2	Indirect with Dynamic Data Validation
	3.3	Building Intricate Validation structures

PRACTICE YOUR SKILLS WITH THESE FREE EXERCISES🤗