Functions
STDEVPA
Population standard deviation including text and logical values
Try it
When to use it
When should I use STDEVPA?
Use STDEVPA when you need the population standard deviation but your data includes text or logical values that should be treated as 0 or 1 rather than ignored.
Used in
Syntax
STDEVPA(value1,...)Examples
=STDEVPA(1,2,3,4,5,6,7,8,9,10) // => 2.8722813232690143