Formula for multiplying with rounding included
Okay, so I need to come up with a formula that does 2 things:
- Multiples the numbers in ColumnA with the numbers in ColumnB
- Rounds those numbers up or down depending on what the nearest .5% is
For example:
ColumnA has 6 in it
ColumnB has 70% in it
Multiplying those together, gives me 4.2. I need that to automatically round down to 4 since 4.2 is closer to 4 than it is to 4.5.
Tags:
Answers
-
- the formula is pretty simple =[Column4]@row * [Column5]@row (the * character multiplies)
- Have you tried using this on your tool bar :
The 0 figures with the arrows shift the decimal places and will do what you've asked !
-
hmm, the icons move the decimal but they don't round the numbers. For example, if I have 4.2, I need it to automatically round down to 4 or if there's 4.4, it should round up to 4.5.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 378 Global Discussions
- 208 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 33 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!