topic Re: How to simulate the Excel RoundUp function. in QlikView https://community.qlik.com/t5/QlikView/How-to-simulate-the-Excel-RoundUp-function/m-p/432433#M699372 <HTML><HEAD></HEAD><BODY><P>That worked.&nbsp; Thanks!</P></BODY></HTML> Wed, 12 Dec 2012 21:06:51 GMT 2012-12-12T21:06:51Z How to simulate the Excel RoundUp function. https://community.qlik.com/t5/QlikView/How-to-simulate-the-Excel-RoundUp-function/m-p/432431#M699370 <HTML><HEAD></HEAD><BODY><P>Does anyone know how to simulate the Excel RoundUp function in the QV script?&nbsp; I need to round 1.2 up to the number 2.&nbsp;&nbsp; Thanks. </P></BODY></HTML> Wed, 12 Dec 2012 21:00:01 GMT https://community.qlik.com/t5/QlikView/How-to-simulate-the-Excel-RoundUp-function/m-p/432431#M699370 2012-12-12T21:00:01Z Re: How to simulate the Excel RoundUp function. https://community.qlik.com/t5/QlikView/How-to-simulate-the-Excel-RoundUp-function/m-p/432432#M699371 <HTML><HEAD></HEAD><BODY><P>hi</P><P></P><P>Try like this</P><P></P><P>Ceil() concept</P><P></P><P>=Ceil(1.2) gives 2</P></BODY></HTML> Wed, 12 Dec 2012 21:01:33 GMT https://community.qlik.com/t5/QlikView/How-to-simulate-the-Excel-RoundUp-function/m-p/432432#M699371 MayilVahanan 2012-12-12T21:01:33Z Re: How to simulate the Excel RoundUp function. https://community.qlik.com/t5/QlikView/How-to-simulate-the-Excel-RoundUp-function/m-p/432433#M699372 <HTML><HEAD></HEAD><BODY><P>That worked.&nbsp; Thanks!</P></BODY></HTML> Wed, 12 Dec 2012 21:06:51 GMT https://community.qlik.com/t5/QlikView/How-to-simulate-the-Excel-RoundUp-function/m-p/432433#M699372 2012-12-12T21:06:51Z