Numeric Functions Menu

  • Bookmark and Share

Items under the Numeric Functions menu are used to manipulate values or formulae.

Round Off adds the Excel round function to the value or formula in the cell or range of cells selected.

Ceiling adds the Excel ceiling function to the value or formula in the cell or range of cells selected.

Markup by Value marks up the value or formula in the selected cell, or range of cells, by a fixed percentage entered by the user.

Markup by Cell Reference marks up the value or formula in the selected cell, or range of cells, by adding a reference to another cell selected by the user.

Auto Number automatically adds numbering to the leftmost cells in the selected range, if the cells included in the selected range to the right of each are not blank.  The top left cell in the range is assigned a value of 1 if it is blank, or contains text.  If it already contains a numeric value, numbering will increment using the existing value as a start value.

WARNING:  Auto Number clears the contents of all visible cells in the leftmost column of the selected range before adding new numbering!

We use cookies to personalise content and to analyse our traffic. You consent to our cookies if you continue to use our website.