Rounding up Number

[daviper]

To all the gurus, how do I round up a field that contains a number? Basically like this,

Field A = Calculation which result as a number

Field B = Round up of Field A's result.

So, let's say Field A is 345.670 and I want Field B to be 345.700

TIA

Edited April 7, 2008 by Guest

[Lee Smith]

There is a Round Function. i.e. Round ( number ; precision ) where you can control the round with the number of places (precision).

But to understand what you are really wanting, you need to provide an example if the Round Function isn't what you are looking for.

10.3755555

10.5555

10.80

Lee

[mr_vodka]

Is this for display only? If so, then you dont really need a second field. You can take Field A, and then under number format, then in an option for number of digits. ( Control-click for Mac)

If you definately need a second calc field then look into Round(FieldA;N) Where N is the number of digits you want to round to.

[daviper]

Yes, I am aware of that but the Round function doesn't let me to put a field. eg. Round (Field B,-2) gave me a blank field on view mode.

[Lee Smith]

why are you using a minus sign.

If you want to round to whole numbers, just make it Round (Field B; 0 )

[daviper]

Tried Round(Field B;0) still got a blank. :

[mr_vodka]

Uhmmm wouldnt it be Round([color:red]Field A;0) ?

Also with the example you just added...

So, let's say Field A is 345.670 and I want Field B to be 345.700

you want it rounded to the tenth, so it would be:

Round([color:red]Field A; 1)

[daviper]

Got it! Thanks guys! Found the solution. :

[Lee Smith]

:hair:

Good catch.

[color:red]daviper,

You don't need a second field, you can use the Auto Enter Option on Field A, and it will change it to what you want.

If you need more information about this, let me know.

Lee

[dwins]

This formula rounds positive numbers up.

Let ( [

a = 234.000003 ; //number

b = 2 ; //decimal places

c = 1/10^b ] ;

Ceiling ( a / c ) * c ) //gives 234.01

[Stickybeak]

I need to round a decimal to the next nearest multiple of .25 - any suggestions?

[comment]

Try =

Round ( number * 4 ; 0 ) / 4

[Stickybeak]

sorry - next highest multiple of .25

[comment]

Well, then =

Ceiling ( number * 4 ) / 4

[Stickybeak]

tremendous - thanks for your help