Mel C Roberts
New Member
- Joined
- Feb 26, 2002
- Messages
- 40
Please help.
I need to round information in a spreadsheet to the nearest 0.25
So data either reads, for example, 1.25, 1.50, 1.75 or 2.00 and nothing in between i.e. if the value is 1.3 it would round down to 1.25 and if it was 1.4 it would round up to 1.5
I am sure this is not too tricky but is driving me crazy!!
Please help
I need to round information in a spreadsheet to the nearest 0.25
So data either reads, for example, 1.25, 1.50, 1.75 or 2.00 and nothing in between i.e. if the value is 1.3 it would round down to 1.25 and if it was 1.4 it would round up to 1.5
I am sure this is not too tricky but is driving me crazy!!
Please help