VARPA Function in Excel: Population Variance Counting Text and TRUE/FALSE

VARPA Function in Excel: Population Variance Counting Text and TRUE/FALSE 1
⏱ 1 min readUpdated 5 October 2026

StatisticsLevel: IntermediateAvailable in: Excel 2007+

In this article
  1. Syntax
  2. Examples
  3. Example 1
  4. VARPA in practice
  5. Where you will use it
  6. Worked example
  7. Mistakes people make
  8. Related functions

VARPA is the population version of VARA.

Advertisement

Syntax

=VARPA(value1, [value2], ...)
Argument What it means
value1… Values

Examples

Example 1

=ROUND(VARPA(A2:C2),3)

Result: 1266.667. See the worked example table below for more cases.

VARPA in practice

Where you will use it

  • Mixed complete data
  • Logical data
  • Teaching

Worked example

Value 1Value 2Value 3FormulaResult
80Absent70=ROUND(VARPA(A2:C2),3)1266.667
8070TRUE=ROUND(VARPA(A3:C3),3)1233.556
807090=ROUND(VARPA(A4:C4),3)66.667

Results calculated in Excel. Text counts as 0 and TRUE as 1; compare with the all-numbers row.

Mistakes people make

MistakeWhat to do instead
Text counts as 0Clean first
Sample dataUse VARA

VAR.P

📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.

Keep reading

Excel Functions A–ZCOSH Function in Excel: Hyperbolic CosineExcel Functions A–ZTBILLYIELD Function in Excel: Treasury Bill YieldExcel Functions A–ZLOG Function in Excel: Logarithm to Any Base
Advertisement
✨ Ask AI about this article

Stuck on a step? Ask a question and the AI answers using this article.

Free · AI can be wrong