The reason is that VAR and VAR.S ignore any values other than numbers in references, while VARA evaluates text values as zeros, TRUE as 1, and FALSE as 0. If your data set contains the Boolean and/or text values, the VARA function will return a different result.