Category: Functions

Functions

Excel CONCATENATE Function

236 Views
The ‘CONCATENATE’ function in Excel will amalgamate a series of selected cells into one text string. This formula can be …
Functions

Excel FORMULATEXT Function

190 Views
The ‘FORMULATEXT’ function in Excel will return the formula being used in any given cell in text format. Note that …
Functions

Excel LEN Function

200 Views
The ‘LEN’ function in Excel will return the length (i.e. number of characters) of a given text/numerical string. Whilst the …
Functions

Excel ISEVEN Function

131 Views
The ‘ISEVEN’ formula in Excel is used to ascertain whether or not a value is even. It returns TRUE if …
Compatibility

Excel RANK Function

142 Views
The ‘RANK’ formula in Excel is used to rank numerical values within a list. This formula ranks an input number …
Date and time

Excel DATE Function

776 Views
The ‘DATE’ function in Excel will return a date using individual day, month and year inputs. This function is most …
Functions

Excel ABS Function

214 Views
The ‘ABS’ function in Excel will return the absolute value of any input number. This formula works by returning the …