Take your full list of variables and categorize and recategorize them with =if().

Want to see what the completed formulas should look like?

• You can download the spreadsheet, which contains the completed formulas.
• Your completed formula in cell B2 should look like this: =IF(A2="Apple","Apple","Other")
• Your completed formula in cell C2 should look like this: IF(A2="Apple","Fruit",IF(A2="Banana","Fruit",IF(A2="Carrot","Vegetable",IF(A2="Watermelon","Fruit",""))))