bobletcs123
New Member
- Joined
- Jan 31, 2019
- Messages
- 27
- Office Version
- 365
- Platform
- Windows
Hi All,
Need to be able to round a number >1, to the nearest half, rounding up.
0.87 = 1.
1.17=1.5
1.57=2, etc...
My current formula is just doing it to the nearest half (not necessarily the higher half).
I'm sure theres a ceiling in there somewhere, but not sure.
=IF(A2>1, ROUND(AI2-1)*2, 0)/2, 0))
Thanks in advance!!
Need to be able to round a number >1, to the nearest half, rounding up.
0.87 = 1.
1.17=1.5
1.57=2, etc...
My current formula is just doing it to the nearest half (not necessarily the higher half).
I'm sure theres a ceiling in there somewhere, but not sure.
=IF(A2>1, ROUND(AI2-1)*2, 0)/2, 0))
Thanks in advance!!