Manuals/calci/DOLLARDE

Revision as of 16:09, 22 August 2018 by Devika (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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