---
title: "Carrying out calculations on Labstep"
description: "Step-by-step guide on how to carry out calculations using Tables (spreadsheets) available on Labstep"
url: https://help.labstep.com/en/articles/5519994-carrying-out-calculations-on-labstep
collection: "Interactive elements"
updated: 2026-05-22
language: en
---

# Carrying out calculations on Labstep

Step-by-step guide on how to carry out calculations using Tables (spreadsheets) available on Labstep

_Now that you know how to use_ [_Tables_](https://help.labstep.com/en/articles/3388189-using-tables-on-labstep.md) _on Labstep, learn how you can carry out calculations easily and efficiently. For more advanced calculations, click_ [_here_](https://help.labstep.com/en/articles/3107598-carrying-out-advanced-calculations-on-labstep.md)_._

* * *

# **Calculation basics:**

## **_How to enter a formula or function_**

1.  Navigate to the table of your choice
    
2.  Select a cell
    
3.  Enter **\=** _(equals)_ in a cell
    
4.  Type the needed formula or function
    
5.  Select the cell(s) of your choice
    
6.  Press 'Enter'
    

![A GIF showing how to calculate the average of some selected cells](https://staticfiles.gleap.io/helpcenter/699dc51d2188da0fb351700e/20260224154025_7803.gif)

## Arithmetic o**_perators_**

**+** → addition – e.g. _=D3+C9_

**\-** → subtraction – e.g. _=C6-B3_

**\*** → multiplication – e.g_. =F4\*B8_

**/** → division – e.g. _=G2/A5_

**%** → percentage – _e.g. =B7%_

**^** → exponentiation – _e.g. =H9^2_

## **_Comparison operators_**

**\>** → greater than – _e.g. =A6>A9_

**→ less than – _e.g. =B7_**

**\>=** → greater than equal to – _e.g. =C20>=A5_

**→ less than equal to – _e.g. =D9_**

**\=** → equal to – _e.g. =B3=B6_

**<>** → not equal to – _e.g. =A8<>G1_

## **_Basic Functions_**

SUM → adds the values of the selected cells

AVERAGE → finds the average value of the selected cells

COUNT → counts how many of the selected cells have numbers in them

CONCATENATE → combines the content of the selected cells

MIN → finds the smallest value of all the selected cells

MAX → finds the largest value of all the selected cells

**_Labstep team tip:_** _If you have to select multiple cells, you can simply enter the first and last cell you need separated by a colon. This will include all the cells between the two cells of reference, including them. E.g. =SUM(_**_D3:D96_**_)_

# **Cell references basics**

## **_Reference operators_**

**,** → union, combines multiple references into one reference – _e.g. =A1,J12_

: → range, all cells between two referenced cells, including the two cells – _e.g. =C2:F4_

@ → reference, indicates implicit intersection in the formula – _e.g. =@A1:D10_

## **_Absolute references_**

\=C2 → the relative reference of cell C2

\=$C2 → the column is absolute and the row relative

\=C$2 → the row is absolute and the column relative

\=$C$2 → absolute reference of cell C2

All done? To learn how to use cell references on Labstep, click [here](https://help.labstep.com/en/articles/3107598-carrying-out-advanced-calculations-on-labstep.md).

* * *

**_Still need help?_**

_Contact us_ [_here_](mailto:info@labstep.com) _or start a conversation with a member of our team using our in-app chat._