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 >>

DATEDIF function

DATEDIF

Function name DATEDIF
Type Date
Arguments – start_date
– end_date
– interval
Syntax =DATEDIF(start_date, end_date, interval)
Description Returns the difference between two date values in years, months, or days.

The Arguments description:

  1. start_date – start date in Date format.
  2. end_date – end date in Date format.
  3. interval – interval type to be used (years, months or days). See below.
Interval Result
“Y” Difference in complete years
“M” Difference in complete months
“D” Difference in days
“MD” Difference in days, ignoring months and years
“YM” Difference in months, ignoring days and years
“YD” Difference in days, ignoring years

Examples:

=DATEDIF(D2,D3,"D")
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 >>