Function

[renuka_sasikumar]

What is the function used to show 2.3 as 3.

[Siva_Sankar]

Round(2.3)

Regards.

Siva

[arulsettu]

hi

use round of function...

[MK_QSL]

round( x [ , base [ , offset ]])

Rounding of x upwards or downwards to the nearest multiple of base with an offset of offset. The result is a number. If x is exactly in the middle of an interval, it is rounded upwards.

Examples:

round( 2.4 ) returns 2

round( 2.6 ) returns 3

round( 2.5 ) returns 3

round( 3.88 , 0.1 ) returns 3.9

round( 3.88 , 5 ) returns 5

round( 1.1 , 1 , 0.5 ) returns 1.5

[#5]

frac() returns the decimal part

floor() returns the integer part

frac(x)+floor(x) = x

Fabrice

[NavinReddy]

=Ceil(2.3) try this

[#7]

hi try this

ceil( 2.3 ) returns 3

[#8]

hi Renuka,

i think u got Answer for your question so please mark this question As answered by choosing Correct answer

so it will help others also

those who are searching for same type Of Qustions

[jagan]

Hi,

Try

Ceil(Number)

Regards,

Jagan.

[amit_saini]

Hi Renuka,

Try this :

Ceil(Your_Field) as Your_number

Thanks

AS