Skip to content

Instantly share code, notes, and snippets.

@sdhutchins

sdhutchins/pevaluate.vba

Created September 8, 2018 00:06
Show Gist options
  • Save sdhutchins/92eeae662c54fde2ee7f22d1e1b0bd3c to your computer and use it in GitHub Desktop.
Save sdhutchins/92eeae662c54fde2ee7f22d1e1b0bd3c to your computer and use it in GitHub Desktop.
Download ZIP
Evaluate 2 pvalues and update data with symbols
Raw
pevaluate.vba
Function pevaluate(p1 As Integer, p2 As Integer, data As String)
If p1 <= 0.05 And p2 <= 0.05 Then
pevaluate = data & "*†"
ElseIf p1 <= 0.05 Then
pevaluate = data & "*"
ElseIf p2 <= 0.05 Then
pevaluate = data & "†"
End If
End Function
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment