How to compute the variance of two percentages?

I would like to compute for the Success Measure Variance of the two percentages. The target success measure is fixed and the actual one is manually inputted.

I tried to subtract them but it will lead to 0 if the actual becomes 95 (meeting the target) but shouldnt it be 100% if it met already?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!