baggers719
Board Regular
- Joined
- Sep 18, 2009
- Messages
- 104
I have a list of numbers I'm trying to round up.
For example I am trying a hlookup for a list of items such as
8.1, 8.23, 7.97, 8.55
The above numbers should round up to the nearest quarter.
I.e. 8.1 = 8.25, 8.23 = 8.25, 7.97=8.0, 8.55=8.75.
Any ideas?
Thanks!
Sean.
For example I am trying a hlookup for a list of items such as
8.1, 8.23, 7.97, 8.55
The above numbers should round up to the nearest quarter.
I.e. 8.1 = 8.25, 8.23 = 8.25, 7.97=8.0, 8.55=8.75.
Any ideas?
Thanks!
Sean.