Calculates the variance based on a sample, including numbers, text, and logical values.
이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.
VARA(value1, [value2], ...)The VARA function estimates variance based on a sample of data. Unlike the VAR.S function, VARA evaluates text and logical values (TRUE/FALSE) within references, treating text as 0 and TRUE as 1.
=VARA(10, "text", TRUE)결과: 25
Calculates variance for 10, 0 (text), and 1 (TRUE).
VARA treats text strings as the number 0.