=Rounddown( not rounding down
Hi All.
I have two cells Text/Number each and looking for the average of, but regardless of how I construct the formulas I end up with 35.700%, What I want is 35.7%. Results cell is formatted to % and to the lowest allowable decimal. Have I missed something?
=AVG([Total Activations Yr24]@row, [Completed design tasks]140)
=ROUNDDOWN(AVG([Total Activations Yr24]@row, [Completed design tasks]140) * 100, 1) / 100
=ROUND(AVG([Total Activations Yr24]@row, [Completed design tasks]140) * 100, 1) / 100
Thanks for any help.
Cheers.
Answers
-
Hi @Jason P,
I just tested this out on my sheet and I think I got it to work the way that you want it.
Incorrect:
=AVG(Value@row, [Value 2]@row) / 100
Now using ROUNDDOWN with 1 decimal place:
=ROUNDDOWN(AVG(Value@row, [Value 2]@row) / 100, 1)
This was bad it made everything after the decimal "00". So I went back to the first formula and adjusted my column's decimal position:
=AVG(Value@row, [Value 2]@row) / 100
I think this 3rd screenshot is what you want? Is this correct?
SSFeatures - The browser extension that adds more features into SmartSheet.
- Automatic sorting, sorting with filters, saving sort settings
- Spell checking
- Report PDF generator that supports grouped and summarized reports
-
-
You're welcome!
SSFeatures - The browser extension that adds more features into SmartSheet.
- Automatic sorting, sorting with filters, saving sort settings
- Spell checking
- Report PDF generator that supports grouped and summarized reports
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!