instead just rounds up to nearest digit regardless of the value...

• Click on the cell where you want the result to appear.
• Type " =ROUNDUP( ".
• Enter the data value.
• Type a comma "," and enter the number of decimal places the data is to be rounded to.
• Type " ) " then press the "Enter" key

• Click on the cell where you want the result to appear.
• Type " =ROUNDUP( ".
• Enter the coordinate of the data cell.
• Type a comma "," and enter the number of decimal places the data is to be rounded to.
• Type " ) " then press the "Enter" key

Note: The Ripple effect and auto update.

• Click on the cell where you want the result to appear.
• Type " =ROUNDUP( ".
• Enter the coordinate of the data cell.
• Type a comma "," and enter the number of decimal places the data is to be rounded to.
• Type " ) " then press the "Enter" key
• Drag the fill handle to fill the column.

Note: The intelligent autofill.