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.