Difference between revisions of "Manuals/calci/DOLLARDE"

From ZCubes Wiki
Jump to navigation Jump to search
 
(One intermediate revision by the same user not shown)
Line 4: Line 4:
 
*<math>FractionalDollar</math> is a dollar value in fraction
 
*<math>FractionalDollar</math> is a dollar value in fraction
 
*<math>Fraction</math> is the integer to use as a denominator
 
*<math>Fraction</math> is the integer to use as a denominator
 
+
**DOLLARDE(), converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number.
DOLLARDE() converts a dollar price in fraction into decimal dollar price.
 
  
 
== Description ==
 
== Description ==

Latest revision as of 16:09, 22 August 2018

DOLLARDE (FractionalDollar,Fraction)


where,

  • is a dollar value in fraction
  • is the integer to use as a denominator
    • DOLLARDE(), converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number.

Description

DOLLARDE (FractionalDollar,Fraction)

  • Argument is a number that is expressed as an integer part and fraction part, seperated by decimal symbol.
  • Argument is an integer to be used as a denominator in conversion to decimal value.
  • Calci divides the fractional part of by the specified value.

e.g. DOLLARDE(1.07,16) is calculated as ($1 + 7/16 = $1.4375000000000004)

  • should be >=1, else Calci displays #ERROR message.
  • If is not an integer, it is truncated.

Examples

Function Output
DOLLARDE(1.11,18) 1.6111111111111116
DOLLARDE(10.0,16) 10
DOLLARDE(3.1,20) 3.5000000000000004

Related Videos

DOLLARDE

See Also

References