SUM

Purpose

Adds numbers in a range.

Syntax

=SUM(number1,number2,…)

Example:

Product

Sales

A

25000

B

32000

C

18500

D

27500

Formula:

=SUM(B2:B5)

Result:

103000

PRODUCT

Multiplies numbers.

Syntax

=PRODUCT(number1,number2,…)

Example:

=PRODUCT(10,5,2)

Result:

100

ABS

Returns the absolute value of a number.

=ABS(-250)

Result:

250

Useful for calculating differences without negative values.

MOD

Returns the remainder after division.

Syntax

=MOD(number,divisor)

Example:

=MOD(25,4)

Result:

1

Real-World Uses

  • Finding odd/even patterns
  • Installment calculations
  • Cyclic numbering
  • Checking remaining quantities

Practice

Create a worksheet containing sales, quantities and payment values and use SUM, PRODUCT, ABS, and MOD.

PreviousNext