i need to round numbers in a spreadsheet 2 decimal points, in a way that:(adsbygoogle = window.adsbygoogle || []).push({});

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,, cant seem to get it right

any ideas

**Physics Forums | Science Articles, Homework Help, Discussion**

Join Physics Forums Today!

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

# Rounding numbers in microsoft excel

**Physics Forums | Science Articles, Homework Help, Discussion**