ignoring logical values and text in excel

VAR.P function - Function that calculates variance based on the entire set, ignoring logical values and text in Excel
var.p function: function that calculates variance based on the entire set, ignoring logical values and text. support functions from excel 2010 onwards. syntax: var.p (number1, [number2], ...)
VAR.S function - Function that calculates variance based on a sample, ignoring logical values and text in Excel
var.s function: function that calculates variance based on a sample, ignoring logical values and text. support functions from excel 2010 onwards. syntax: var.s (number1, [number2], ...)

ignoring logical values ​​and text in excel