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...
If [gal to order] is between 17 & 22, round to 20
If [gal to order] is between 22.01 & 27, round to 25
etc...
 530 Points
Posted 2 years ago
Ⲇanom the ultimate (Dan Diebolt), Champion
 29,924 Points
I think your math is wrong. If you want to round to the nearest 5, Round(17,5) = 15 not 20.
 530 Points
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
Ⲇanom the ultimate (Dan Diebolt), Champion
 29,924 Points
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
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
 120 Points
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.
To prevent returning a zero use with an if statement to handle values <2.5
This will work with any desired multiple.
Related Categories

Formulas & functions
 2880 Conversations
 71 Followers