I don't know what you mean by variance in this context.

The variance of A2:A100 is =VAR(A2:A100)
If you want the difference between A2 and B2 it is =B2-A2
--
David Biddulph

"copitta" wrote in message
...
I have two columns of scores. I need to calculate the variance
(difference)
across the two columns, with the result in column three. Seems simple but
I
cannot figure it out. Thank you.