nearest whole number (rounding up)

[gcue]

hello.

im trying to get the nearest whole number by rounding up..

im trying to use the round function but am not getting the right whole number

(essentially im trying to get total number of pages - each page can only hold up to 35 items)

so..

$total_pages = Round(UBound($assets) / 35)

any help is greatly appreciated..thanks!

[Melba23]

gcue,

Look at Ceiling in the Help file: "Returns a number rounded up to the next integer"

M23

[eEniquEe]

hello.

im trying to get the nearest whole number by rounding up..

im trying to use the round function but am not getting the right whole number

(essentially im trying to get total number of pages - each page can only hold up to 35 items)

so..

$total_pages = Round(UBound($assets) / 35)

any help is greatly appreciated..thanks!

You can use the Ceiling() function.

Ceiling:

Returns a number rounded up to the next integer.

Like this:

$total_pages = Ceiling(UBound($assets) / 35)

[Yashied]

$total_pages = Int(UBound($assets) / 35) + Int(Mod(UBound($assets), 35) > 0)

[gcue]

PERFECT!!!

thanks!

hehe cool name.. never would have guessed.

[GEOSoft]

For future reference, Floor() does the opposite. It rounds down.