The main difference between VARPA and VAR.S is that VARPA calculates the variance of a population, while VAR.S calculates the variance of a sample. VARPA divides the sum of squares by the number of data points, while VAR.S divides by n-1.