Average doesn't give me expected result

ManuelHofmann

Hi there,

when i do a =ROUND(AVG formular as shown below i expect to get "2" for the average of 1 and 3.

But it shows 3. Any idea how to fix this?

Thank you,

Manuel

Paul Newcome

Because your formula that is outputting the numbers is outputting the 1 as a text value which is not recognized. The AVG function is picking up on only the 3 since it is the only numerical value. Try removing the quotes from around the "1" in the number output formula and see fi that fixes things for you.

ManuelHofmann

The input numbers comes from a another formular to convert the emojis into numbers first. It shows the correct numbers but average calculation doesn't work. When i do not use a formular as input for the average calculation (like 1 and 3 without emoji formular) it works as expected and shows "2"

Paul Newcome

Because your formula that is outputting the numbers is outputting the 1 as a text value which is not recognized. The AVG function is picking up on only the 3 since it is the only numerical value. Try removing the quotes from around the "1" in the number output formula and see fi that fixes things for you.

ManuelHofmann

Ahh, thank you. That was an easy fix! :)

Paul Newcome

Sometimes we get lucky. Haha.

Happy to help. 👍️