Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

How to simulate the Excel RoundUp function.

Does anyone know how to simulate the Excel RoundUp function in the QV script?  I need to round 1.2 up to the number 2.   Thanks.

Tags (1)
1 Solution

Accepted Solutions

Re: How to simulate the Excel RoundUp function.

hi

Try like this

Ceil() concept

=Ceil(1.2) gives 2

2 Replies

Re: How to simulate the Excel RoundUp function.

hi

Try like this

Ceil() concept

=Ceil(1.2) gives 2

Not applicable

Re: How to simulate the Excel RoundUp function.

That worked.  Thanks!

Community Browser