Skip to main content (Press Enter).
Sign in
Skip auxiliary navigation (Press Enter).
Support
Quickbase University
Skip main navigation (Press Enter).
Toggle navigation
Search Options
Home
Communities
All Posts
All Communities
My Communities
Getting Started
Events
Qrew Groups
Discussions
View Only
Community Home
Discussion
64.7K
Library
549
Blogs
177
Events
0
Members
46.7K
Back to discussions
Expand all
|
Collapse all
sort by most recent
sort by thread
What is the formula to round up or down to the nearest ""5
BuildPro
11-15-2016 21:15
Need a formula for the following: If [gal to order] is between 17 & 22, round to 20 If [gal to order] ...
_anom Diebolt)
11-15-2016 22:17
I think your math is wrong. If you want to round to the nearest 5, Round(17,5) = 15 not 20.
BuildPro
11-16-2016 22:45
No math involved. I want all numbers between 17 & 22 to round to the number 20. Some will round ...
_anom Diebolt)
11-17-2016 13:31
I can't image a world without Math. Numb3rs Scene: Everything is numbers, Math is everywhere https://www.youtube.com/watch?v=vFRTgr7MfWw ...
Phil Pinkham
07-14-2017 20:58
Round([gal to order]/5)*5 To prevent returning a zero use with an if statement to handle values <2.5 ...
1.
What is the formula to round up or down to the nearest ""5
0
Like
BuildPro
Posted 11-15-2016 21:15
Reply
Reply Privately
Options Dropdown
Need a formula for the following:
If [gal to order] is between 17 & 22, round to 20
If [gal to order] is between 22.01 & 27, round to 25
etc...
2.
RE: What is the formula to round up or down to the nearest ""5
0
Like
_anom Diebolt)
Posted 11-15-2016 22:17
Reply
Reply Privately
Options Dropdown
I think your math is wrong. If you want to round to the nearest 5, Round(17,5) = 15 not 20.
3.
RE: What is the formula to round up or down to the nearest ""5
0
Like
BuildPro
Posted 11-16-2016 22:45
Reply
Reply Privately
Options Dropdown
No math involved. I want all numbers between 17 & 22 to round to the number 20. Some will round up, some will round down. Also, 22.01 through 27 would round to 25...so on and so forth. Thx
4.
RE: What is the formula to round up or down to the nearest ""5
0
Like
_anom Diebolt)
Posted 11-17-2016 13:31
Reply
Reply Privately
Options Dropdown
I can't image a world without Math.
Numb3rs Scene: Everything is numbers, Math is everywhere
https://www.youtube.com/watch?v=vFRTgr7MfWw
If(
[gal to order] >=17 and [gal to order] <22, 20,
[gal to order] >=22 and [gal to order] <27, 25
)
An amazing story about an amazing mathematician:
Srinivasa Ramanujan
https://www.youtube.com/watch?v=Y7Ufxl-zSRI
5.
RE: What is the formula to round up or down to the nearest ""5
0
Like
Phil Pinkham
Posted 07-14-2017 20:58
Reply
Reply Privately
Options Dropdown
Round([gal to order]/5)*5
To prevent returning a zero use with an if statement to handle values <2.5
This will work with any desired multiple.
×
New Best Answer
This thread already has a best answer. Would you like to mark this message as the new best answer?
Skip Navigation Links
Terms and Conditions
Copyright . All rights reserved.
Powered by Higher Logic