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
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!