- #1
Dell
- 590
- 0
i need to round numbers in a spreadsheet 2 decimal points, in a way that:
for a number with a.byX
for x>5 i need to round upwards
for x<5 i need to round downwards
for x=5 i need to round up if y is odd and round down if y is even
for example
0.563~0.56
0.566~0.57
0.575~0.58
0.565~0.56
i tried using if, roundup, rounddown, floor,, can't seem to get it right
any ideas
for a number with a.byX
for x>5 i need to round upwards
for x<5 i need to round downwards
for x=5 i need to round up if y is odd and round down if y is even
for example
0.563~0.56
0.566~0.57
0.575~0.58
0.565~0.56
i tried using if, roundup, rounddown, floor,, can't seem to get it right
any ideas