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 …