Using the ROUND function similar to MS Excel 1

[pnad]

Hello all,

I need to use the ROUND function in ASP similar to the functionality of ROUND in excel. Basically, I need to be able to pass -ve numbers as number of decimal places.

E.g.

ROUND in excel
round(-182294.81,-5) = -200000

How do I accomplish this using javascript/vbscript or any in-built ASP functions.

All help is appreciated.

Thanks.

 

[TheCandyman]

There is a round function built in, but it only does somthing like this

Round(4.984621) = 5

You'll need something like this

http://classicasp.aspfaq.com/general/how-do-i-round-a-number-properly-with-vbscript.html

 

[tsuji]

Roughly this, with m positive or negative alike.
[tt]
m=-5
n=-182294.81
p=round(n*10^m)*10^(-m)
[/tt]

 

[pnad]

Thank you all. I was able to use the formula successfully.