Exceliscool123456789
New Member
- Joined
- Sep 5, 2023
- Messages
- 30
- Office Version
- 365
- Platform
- Windows
Hi,
I need a formula to show a value being increased to a certain decimal (.25, .5, .75, 00) everytime the value is between certain ranges. Essentially rounding the value to .25 decimal points whichever one is lower?
I.e. -
9.16 = 9.25
10.74 = 10.75
11.96=12
5.33 = 5.50
I need a formula to show a value being increased to a certain decimal (.25, .5, .75, 00) everytime the value is between certain ranges. Essentially rounding the value to .25 decimal points whichever one is lower?
I.e. -
9.16 = 9.25
10.74 = 10.75
11.96=12
5.33 = 5.50