HAND OUT ON ROUNDING



HAND OUT ON ROUNDING

|Round |Rounds down numbers below 5 to the nearest lower number and five and above to the next higher number |

| |=round(a2,0) |

|Roundup |Rounds up to the next higher number only |

| |=roundup(a2,0) |

|Rounddown |Ignores fraction and rounds the number down to the nearest lower number |

| |=rounddown(a2,0) |

|Mround |Rounds down numbers below 5 to the nearest given multiple (10, 100, 1000 etc) and five and above to the next |

| |higher multiple. |

| |=mround(a2,10) |

|Ceiling |Rounds up the next higher given multiple like 10, 100, 1000 etc. |

| |=ceiling(a2,10) |

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download