Average doesn't give me expected result
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
Best Answer

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.
Answers

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"

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.

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

Sometimes we get lucky. Haha.
Happy to help. 👍️
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.6K Get Help
 63 Global Discussions
 68 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!