Round to nearest X

Rounds the number to the nearest specified number

Type: Import/Export

Description: Converts the cell value to a number and rounds the value to the nearest specified digits.

Scope: Supports only positive and negative integers.

Example

• Cell value: 1234.5678 mm

• Rule values:

  • Round to nearest X: 10

  • Ignore text: kg|Kg|g|mg|m|mm|each|L|ml|oz|fl

• Result: 1230