In this article
VARA is VAR.S that counts text as 0 and TRUE as 1.
Advertisement
Syntax
=VARA(value1, [value2], ...)| Argument | What it means |
|---|---|
value1… |
Values |
Examples
Example 1
=ROUND(VARA(A2:C2),3)Result: 1900. See the worked example table below for more cases.
VARA in practice
Where you will use it
- Mixed data columns
- Logical surveys
- Attendance with text
Worked example
| Value 1 | Value 2 | Value 3 | Formula | Result |
|---|---|---|---|---|
| 80 | Absent | 70 | =ROUND(VARA(A2:C2),3) | 1900 |
| 80 | 70 | TRUE | =ROUND(VARA(A3:C3),3) | 1850.333 |
| 80 | 70 | 90 | =ROUND(VARA(A4:C4),3) | 100 |
Results calculated in Excel. Text counts as 0 and TRUE as 1; compare with the all-numbers row.
Mistakes people make
| Mistake | What to do instead |
|---|---|
| Text counts as 0 | Use VAR.S to ignore |
| Units | Squared units |
Related functions
📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.
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