yfzracer912
New Member
- Joined
- Dec 1, 2009
- Messages
- 1
I have an Excel project for school and I cant figure out how to round a number(digit) if its odd or even. Example:
rounding rules for values ending in 5: 2.765--> 2.76 number preceding the 5 is even, round down
but 2.775--> 2.78 number preceding the 5 is odd, round up
Do I have to use Clever round? I am lost on this one.
Thanks.
rounding rules for values ending in 5: 2.765--> 2.76 number preceding the 5 is even, round down
but 2.775--> 2.78 number preceding the 5 is odd, round up
Do I have to use Clever round? I am lost on this one.
Thanks.