Rounding JavaScript to negative decimal places like Excel

Question

I am trying to round a number in JavaScript to match the rounding in Excel.

Excel:

=ROUND(123456,-1)

which outputs

How can I force JavaScript to round to negative decimal places?

+3

dibs 23 Mar 12 at 1:02

2 answers

Formula.js implements all math functions offered by Microsoft Excel 2013, including ROUND.

0

Ismael ghalimi 04 jan. 13 at 18:44

Kendall frey · Accepted Answer · 2012-03-23T01:06:57+0000

function round(x, places)
{
    var shift = Math.pow(10, places);
    return Math.round(x * shift) / shift;
}