Try$-$it $3$

Create an IF with a nested AND function.

Resources

You'll need the following resources for this try$-$it:

Open L$1\_$T$1\_$try$3\_$results$\_$starter.xIsx in this lesson's Learning Activity Resources.

Analyzing data

Instructions

The following are the general tasks that you must perform during this try$-$it:

Create a formula in cell $C6$ that gives a result of Ideal if the sample result for Magnesium is less than $200$ and less than the sample results of Potassium. If not, the result should be Retest.

Fill the formula for Sodium and Sulphur.

Save the file as the same filename plus your initials.