Generating new data in excel with missing values

This video shows the use of IF function with OR and AND logical operations to generate a new variable which does not give any error. As if there is error then it will make the data in string form while importing in softwares like stata, eviews etc.