Excel Function of the Month – ROUND


The Excel Function of the month is

ROUND

Description

Rounds a number to a specified number of digits.

Usage

The ROUND function has two parameters : The first is the cell containing the number to be rounded, the second is how many decimal points you want to round off to.

Here is an example of ROUND being used in a calculation:

Check out my Excel posters for your classroom

Excel-Functions-PostersI have created posters that you can stick up in your class. There are 33 posters. Below is an index of what functions are available and a sample sheet (to the right) showing what the posters look like. You can purchase them from the Tech Teachers online shop.

Functions covered

AND, AVERAGE, CONCATENATE, COUNT, COUNTA, COUNTBLANK, COUNTIF, DATE, FIND, INT, LARGE, LEFT, LEN, LOWER, MAX, MEDIAN, MID, MIN, MODE, NOW, OR, POWER, RAND, RANDBETWEEN, RIGHT, ROUND, SMALL, SUM, SUMIF, TIME, TODAY, UPPER, VLOOKUP

Find out more about the posters here

Similar Posts: