Ian's Excel Add-in Ribbon Menu

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, the 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!