Now that you know how to use Tables on Labstep, learn how you can carry out calculations easily and efficiently. For more advanced calculations, click here.
Navigate to the table of your choice
Select a cell
Enter = (equals) in a cell
Type the needed formula or function
Select the cell(s) of your choice
Press 'Enter'
+ → 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
> → 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
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)
, → 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
=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.
Still need help?
Contact us here or start a conversation with a member of our team using our in-app chat.
