Excel like a finance pro.
← The libraryPractice · 2 questions →
Statistical function
VARPA
Calculates population variance, counting text as 0 and TRUE as 1.
Rarely usedDifficulty 1250 · ProficientUsage rank #294 of 520
When to use it
Population variance that counts text as 0 and logicals as 1 or 0.
The shape of it
- Syntax
=VARPA(value1, [value2], ...)
Worked examples
Plain numbers
=VARPA(2,4,4,4,5,5,7,9) → 4
Same as VAR.P on plain numbers.
With a logical
=VARPA(1,2,TRUE) → 0.222222222
Population variance of 1, 2, 1.
With text
=VARPA(A2:A4) → 22.22222222
10, 0, and text as 0.
Worth knowing
- VAR.P for normal population data.
- Placeholders count as zero.
- Blanks are ignored.
Where it goes wrong
- Text as 0 distorts the result.
- Numbers stored as text count as 0.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.