Alright...based on your example, I'll assume you have a data element in cell C9, and a calculated mean in cell D36. If you wanted to calculate the deviation from the mean for the data in cell C9, ONLY if C9 actually had data in it, you could say this:


Code:
=IF($C9="","",ROUND(($C9-$D36),2))