I'm not sure exactly what you are trying to do as I have not ever exported anything to Excel, but I have auto-populated a field based on a previous selection using the if statement. My question for you is, how are you determining what is compliant and what is not compliant? Whether it has a clear space overlap? If so, then you might try an "if" statement in the calculate field in combination with your note.
if(selected(${clearspaceselected},'yes'),'Not_compliant','Compliant')
In this example, if overlap is selected as yes, then it will give the calculate expression "not complaint", otherwise if it's no, it will return "compliant". You were on the right track with note, but I think you needed the if statement as well in order to return the value you need in an excel export.
Again, I'm flying blind here, but you might try it to see if it does what you need. I used it to populate a serial number if a particular unit that was selected. There are only two units, so it worked for me, I'm not sure what I would have done if there had been more choices...
Hope that helps.
Allison