Skip to main content (Press Enter).
Sign in
Skip auxiliary navigation (Press Enter).
Support
Quick Base University
Skip main navigation (Press Enter).
Toggle navigation
Content types
Announcements
Blogs
Communities
Discussions
Events
Glossary
Site Content
Libraries
Date range
on this day
between these dates
Posted by
Home
Getting Started
Communities
All Communities
My Communities
Celebrate
What's New
Events
User Groups
Browse
Discussion Posts
Library Entries
Discussions
View Only
Community Home
Discussion
32.8K
Library
10
Blogs
91
Events
0
Members
3.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
Lynne8817 Lynne8817
11152016 21:15
Need a formula for the following: If [gal to order] is between 17 & 22, round to 20 If [gal to ...
_anom Diebolt)
11152016 22:17
I think your math is wrong. If you want to round to the nearest 5, Round(17,5) = 15 not 20.
Lynne8817 Lynne8817
11162016 22:45
No math involved. I want all numbers between 17 & 22 to round to the number 20. Some will round...
_anom Diebolt)
11172016 13:31
I can't image a world without Math. Numb3rs Scene: Everything is numbers, Math is everywhere h...
Phil Pinkham
07142017 20:58
Round([gal to order]/5)*5 To prevent returning a zero use with an if statement to handle values &l...
1.
What is the formula to round up or down to the nearest ""5
0
Like
Lynne8817 Lynne8817
Posted 11152016 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
Top
Contributor
_anom Diebolt)
Posted 11152016 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
Lynne8817 Lynne8817
Posted 11162016 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
Top
Contributor
_anom Diebolt)
Posted 11172016 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=Y7UfxlzSRI
5.
RE: What is the formula to round up or down to the nearest ""5
0
Like
Phil Pinkham
Posted 07142017 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