Manuals/calci/ROUND

From ZCubes Wiki
Revision as of 20:43, 24 October 2013 by MassBot1 (talk | contribs) (Created page with "<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify"> Syntax </div></div> ---- <div id="4SpaceContent" align="left"><div class="ZEditBox" align=...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Syntax


Remarks


Examples


'''''''  ''''

Description


ROUND


 

ROUND (N,Nd)

N   is the number which is to round and Nd specifies the number of digits.


Column1
Column2
Column3 Column4
Row1 3.6712 2
Row2 3.67
Row3
Row4
Row6
'



·        When Nd is greater than zero,the number is rounded to the specified number of decimal places.

·        When  Nd is 0, the number is rounded to the nearest integer.

·        When Nd  is less than 0, the number is rounded to the left of the decimal point.

 





Rounds a number to a specified number of digits.




Let’s see an example in (Column1 Row 1,Column2Row1)

ROUND (N,Nd)

ROUND (C1R1,C2R1)

i.e. =ROUND(3.6712,2) is 3.67