I got probrems in rounding up numbers

[icekube88]

can u round this off to the nearest thousand
e.g

no = 13845

the result should be

14000

i try using round(13845,-3) i got an error

 

[johnwm]

Hi and welcome to Tek-Tips. To get the best from the forum, please read faq222-2244, which helps you get the best answers.

For this one you will get quite close with:
[tt]
1000*Round(no/1000)
[/tt]
But remember that Round does statistical rounding, that is Round(2.5) becomes 2, but Round(3.5) becomes 4.

For consistent treatment use Int:[tt]

1000*(Int((no/1000) + .5))
[/tt]
which rounds all .5 up

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'

 

[Glasgow]

Divide by 1000 first

round(13845/1000)*1000

 

[Glasgow]

Johnwm 1, Glasgow 0

 

[johnwm]

C'mon Glasgow, speed up that keyboard

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'

 

[Glasgow]

Johnwm - I did mine suspended from the ceiling by a rope and drinking a pint of lager just for the challenge which explains the typing speed but not the omission (int etc). Perhaps I'll replace the rope with a second pint next time in case the rope is affecting my concentration.