For example, you might enter =VAR.S(B12:B32) to find the variance for the data in cells B12 to B32. Important You must start with the "=" so that Excel knows you are entering a formula.

First time to stick my toe into this part of the fora! Two Excel questions that I cannot find an answer to here or anywhere else on the internets. I have access to Excel 2007 PC and Excel 2004 Mac ...