Using nested IF commands for string data coding/transformation in Excel @AnotherPsi
Using nested IF commands for string data coding/transformation in Excel @AnotherPsi
Uploaded December 2016 | Updated September 2026, 1 hour ago
I illustrate how to use nested IF commands in Excel (2016; but should work in all others) to transform string/worded data into coded numerals automatically.

Command used: =IF(B2="White";1;IF(B2="Black";2;IF(B2="Indian";3;IF(B2="Hispanic";4;IF(B2="Asian";5;IF(B2="Other";6;0))))))

Our Facebook page: facebook.com/socialscienceclubofficial
Our blog: socialscienceclub.com
Using nested IF commands for string data coding/transformation in ExcelPost-event information and a changing memory | Loftus & Palmer (1974)Installing R and R-Studio - Windows 10SPSS Tutorial: How to create custom tablesSweet Sabotage: Inside the Vipeholm ExperimentSPSS Tutorial: Multiple regression and assumption testing5 controversial psychological studiesPhineas Gage: a case studySPSS Tutorial: Inter and Intra rater reliability (Cohens Kappa, ICC)Taijin Kyofusho: Japanese Social AnxietyThe Little Albert ExperimentLoftus and Palmers Eyewitness Testimony Study
Another Psi |

Using nested IF commands for string data coding/transformation in Excel

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER