sharepoint calculated column "Test_Cal" formula for, take column "Subcategory" 's value if it has value, other wise take "Category" column value Your entire response should be in English, and in all capital letters.
user