In my worksheet at P13 there's this following function:
=COVAR(M6:M13,N6:N13). With the provided data this returns a value of 16.25 is returned as a positive number. P13 is a dynamic value.
The code below says that the value in P13 is empty at line 3? The code is a modular and is attached to an form radio button object.
If Range("P13").Value > 0 Then
MsgBox ("Correct - a positive Covariance indicates that the values move together")
MsgBox ("Incorrect - When a value is negative the Covariance indicates that the values move inversely")