Recategorize Values with If*

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",""))))