Difference between revisions of "Manuals/calci/FIXEDBAD"

From ZCubes Wiki
Jump to navigation Jump to search
 
(One intermediate revision by the same user not shown)
Line 14: Line 14:
  
 
==Examples==
 
==Examples==
 +
# FIXEDBAD(189.434,2) = 189.43
 +
# FIXEDBAD( 27.987,1) = 27.9
 +
# FIXEDBAD(2.14326,4) = 2.1432
 +
 +
==Related Videos==
 +
 +
{{#ev:youtube|v=W6hBDPSSu0U|280|center|Fixed}}
  
 
==See Also==
 
==See Also==

Latest revision as of 12:47, 25 March 2019

FIXEDBAD (num,decimalNum,bolLeadingZero,bolParens)


  • is any number.
  • is any decimal value.

Description

  • This function used to fix the given decimal places.
  • In , is any number.
  • is number which is used to correct the decimal places.
  • To fix the decimal numbers the following rule is to be followed:If 5 or above then round the last number up.
  • If 4 or below the last number stays the same.Suppose to round off decimal numbers to the nearest hundredths, look at the digit in the thousandths place.
  1. When the digit in the thousands place is < 5, the thousandths place and following digits are replace by 0.
  2. When the digit in the thousands place is = or > 5, the digit in the hundredths places is increased by 1 and the following digits become 0.

Examples

  1. FIXEDBAD(189.434,2) = 189.43
  2. FIXEDBAD( 27.987,1) = 27.9
  3. FIXEDBAD(2.14326,4) = 2.1432

Related Videos

Fixed

See Also

References