Forum Discussion
- _anomDiebolt_Qrew EliteI think your math is wrong. If you want to round to the nearest 5, Round(17,5) = 15 not 20.
- BuildProQrew CaptainNo 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
- _anomDiebolt_Qrew EliteI 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 - PhilPinkhamQrew TraineeRound([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.