IF function

IF

Function name IF
Type Logical
Arguments – test
– then_value
– otherwise_value
Syntax =IF(test, then_value, otherwise_value)
Description Checks whether a condition is met and returns one value if true and another value if false.

The Arguments description:

  1. test – a value or logical expression that is to be evaluated.
  2. then_value – the value to return when test
read more >>

VLOOKUP in TotalSheets

VLOOKUP

Function name VLOOKUP
Type Search
Arguments – table
– value
– index
– exactmatch
Syntax =VLOOKUP(table, value, index, exactmatch)
Description Searches down and retrieve data from a specific column in table.

The Arguments description:

  1. table – the table (range) from which to retrieve a value.
  2. value – the value to look for in the first column of a table (range).
  3. index – the column
read more >>

TotalSheets Functions

IMAGE

Function name IMAGE
Type TotalSheets specific
Arguments – src
– mode
– width
– height
– title
Syntax =IMAGE(src, mode, width, height, title)
Description Creates an image from a provided link.

The modes description:

  1. Stretch image to a cell width, keep aspect ratio
  2. Stretch image to a cell size, no aspect ratio
  3. Stretch image to a given size
read more >>

Add function

How To Create Your Own Function

Creating your own function can be easier than you think.

  • Start with a new spreadsheet.
  • In the top menu select ‘Tools’ and then ‘Add function’.
  • New dialog will appear, where you can insert the name of function, arguments (unlimited number separated with commas),

read more >>

TotalSheets Functions

SHEET

Function name SHEET
Type TotalSheets specific
Arguments – sheet_number
– cell_range
Syntax =SHEET(sheet_number, cell_range)
Description Returns the value or range from another sheet in the spreadsheet.

The arguments description:

sheet_number – a sheet number (1, 2, …) or cell address (A1, C7, …), specifying number of sheet,

cell_range – a cell address read more >>