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**

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

# Rounding numbers in microsoft excel

Loading...

Similar Threads - Rounding numbers microsoft | Date |
---|---|

HP 50G complex numbers with a fraction? | Friday at 7:55 PM |

Limitation of the number of search terms in search engines | Dec 21, 2017 |

Article on Numbers and Computers | Apr 5, 2017 |

TI-84 Rounding Error in Fraction Mode | Sep 22, 2015 |

Roundness Measurement - Probes | Feb 19, 2008 |

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