AVERAGEA function in Excel AVERAGEA function in Excel returns the average(Arithmetic Mean) of its arguments. It considers Text and FALSE(boolean) as 0. It considers TRUE(boolean) as 1. Formula =AVERAGEA(value1, [value2], ...) Here, value1, value2, … are the values on which average will be calculated. Atleast one value is …