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 - The Fusion of Science and Community**

# Rounding numbers in microsoft excel

Know someone interested in this topic? Share a link to this question via email,
Google+,
Twitter, or
Facebook

Have something to add?

- Similar discussions for: Rounding numbers in microsoft excel

Loading...

**Physics Forums - The Fusion of Science and Community**