Formulaes and Functions
- Concatenate - joins several text strings into one text
string.
- Left - allows the user to return the first character or
characters in a text string based on the number of characters specified.
- MRound - Returns a number rounded to the
desired multiple.
- Sumif - allows the user to total / add / sum a group of
cells that fulfil certain criteria.