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