Mathematical Functions in Excel

Mathematical functions allow you to perform a variety of calculations in Excel including RoundDown, RoundUp and Sumif. These functions make calculating data contained within a worksheet easier and more efficient.

RoundDown

1. Create the following table:

2. Select cell C3

3. On the Formulas tab in the Function Library group, select Math & Trig

4. Select RoundDown

5. For the Number text box, select B3

6. For the Num_digits text box, type in 0

7. Click OK

The number has been rounded down to the nearest Euro

RoundUp

1. Select cell C3

2. On the Formulas tab in the Function Library group, select Math & Trig

3. Select RoundUp

4. In the Number text box, select B4

5. In the Num_digits text box, type in 0

6. Click OK

The number was rounded up to the nearest Euro

SumIf

1. Select cell B5

2. On the Formulas tab in the Function Library group, select Math & Trig

3. Select SumIf

4. Select B3 and B4 for the Range

5. Type in >20 for the Criteria text box

6. Click OK

7. The selected cells were only calculated if they were above 20 Euro

8. Save the workbook as “Maths”

For further information about Advanced Excel click the link below: