Is there a way to set a rounding method such as the "desired" rounding rule of odd up - even stay?
Examples:
4.25 = 4.2 (In this example, the tenth's digit is even, therefore I would like Excel to round down)
4.35 = 4.4 (In this example, the tenth's digit is odd, therefore I would like Excel to round up)
**Important** I would like Excel to do this computation simultaneously depending the value of a number! Is there a way? (In other words - there will be both cases in a set of computations).
Examples:
4.25 = 4.2 (In this example, the tenth's digit is even, therefore I would like Excel to round down)
4.35 = 4.4 (In this example, the tenth's digit is odd, therefore I would like Excel to round up)
**Important** I would like Excel to do this computation simultaneously depending the value of a number! Is there a way? (In other words - there will be both cases in a set of computations).