If and + if or

Hi,

In my attached data set, I am trying to find a formula which will give me the desired output in Col D. The formula should first check if Type (Col A) = "Home" and only if it is true then it should check Description (Col C). Under Col C it should check if the cell contains full Upper Case text then it should return "Type A" under Col D. If Col C contains lower case or proper case or anything else then it should return "Type B" in Col D. If Col C contains a blank cell then it should return "No Notes". Please note that the Type (Col A) should be equal to "Home", only then proceed with the above checks. If the value of a cell under Col A is not equal to "Home", then it should return a value of "Not Applicable" under Col D. Hope this helps.