Rounding of number 1

[drewduncan]

Hey hope someone can help me!!

Does anyone know of any way to round ALL decimal numbers up to the nxt whole number - e.g 1.1 would be rounded to 2, 2.4 would be rounded to 3 and so on.

Ive looked at the help pages for a while but had no joy.

Any feedback would be great

Cheers

Drew.

 

[PaulBricker]

This will do it.

-1 * (Int([FieldName] * -1))

Paul

 

[PaulBricker]

This will to

Int([FieldName]) +1

Both expression will work for positive and negative numbers.

Paul

 

[danvlas]

Paul...I'm taking my hat off and bowing!
Awesome!
Have one from me!




Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[danvlas]

Nope! the second doesn't!

Int(1) +1 returns 2

But the first one deserves more than a star!!!





Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[drewduncan]

Excellent Paul works good.

Always is something simple n you try to make it harder than it is!!!

Cheers for the help

Drew

 

[PaulBricker]

Well I learned the first one years ago but when I was thinking about it, it seemed odd I never thought of the second one. But then Dan showed me why it doesn't work. Well, I guess I'll keep the first one in my bag and give the second one the boot. Thanks for picking that up Dan.

Paul

 

[danvlas]

Paul...glad you didn't feel offended.

And the simplicity of the first formula makes it BRILLIANT!

Since I can't award you another star, I'll just say 'Wow' once again




Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html