#VALUE!#
Division by zero returns
#VALUE!and produces a warning.AVG(),MIN(), andMAX()return#VALUE!if no numeric values are found.
#VALUE!#Division by zero returns #VALUE! and produces a warning.
AVG(), MIN(), and MAX() return #VALUE! if no numeric values are found.