Difference between revisions of "Manuals/calci/DOLLARDE"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left">  <font color="#000000"><font face="Arial, sans-serif"><font size="2">'''DOLLARDE'''</font><font size="2">(</font><fo...")
 
 
(5 intermediate revisions by 3 users not shown)
Line 1: Line 1:
−
<div id="6SpaceContent" class="zcontent" align="left"> 
+
<div style="font-size:30px">'''DOLLARDE (FractionalDollar,Fraction)'''</div><br/>
  
−
<font color="#000000"><font face="Arial, sans-serif"><font size="2">'''DOLLARDE'''</font><font size="2">(</font><font size="2">'''FD'''</font><font size="2">, </font><font size="2">'''F'''</font><font size="2">)</font></font></font>
+
where,
 +
*<math>FractionalDollar</math> is a dollar value in fraction
 +
*<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.
  
−
<font color="#000000"><font face="Arial, sans-serif"><font size="2">Where 'FD' is a number expressed as a fraction and 'F' is the integer to use in the denominator of the fraction.</font></font></font>
+
== Description ==
  
−
</div>
+
DOLLARDE (FractionalDollar,Fraction)
−
----
 
−
<div id="1SpaceContent" class="zcontent" align="left"> <font color="#000000"><font face="Arial, sans-serif"><font size="2">Tis function converts a dollar price which is in fraction into decimal dollar price.</font></font></font></div>
 
−
----
 
−
<div id="7SpaceContent" class="zcontent" align="left"> 
 
  
−
* <font color="#000000"><font face="Arial, sans-serif"><font size="2">Fraction should be grater than 0 </font></font></font>
+
*Argument <math>FractionalDollar</math> is a number that is expressed as an integer part and fraction part, seperated by decimal symbol.
 +
*Argument <math>Fraction</math> is an integer to be used as a denominator in conversion to decimal value.
 +
*Calci divides the fractional part of <math>FractionalDollar</math> by the specified <math>Fraction</math> value.
  
−
</div>
+
e.g. DOLLARDE(1.07,16) is calculated as ($1 + 7/16 = $1.4375000000000004)
−
----
 
−
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
 
  
−
DOLLARADE
+
*<math>Fraction</math> should be &gt;=1, else Calci displays #ERROR message.
 +
*If <math>Fraction</math> is not an integer, it is truncated.
  
−
</div></div>
+
== Examples ==
−
----
 
−
<div id="8SpaceContent" class="zcontent" align="left"><font color="#000000"><font face="Arial, sans-serif"><font size="2">Lets see an example,</font></font></font>
 
  
−
<font color="#000000"><font face="Arial, sans-serif"><font size="2">DOLLARDE(FD, F)</font></font></font>
+
<div id="6SpaceContent" class="zcontent" align="left">
−
 
 
−
<font color="#000000"><font face="Arial, sans-serif"><font size="2"><nowiki>=DOLLARDE(1.11,18) is 1.611</nowiki></font></font></font>
 
−
 
 
−
<br /><br />
 
−
 
 
−
<br /><br />
 
−
 
 
−
</div>
 
−
----
 
−
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
 
−
----
 
−
<div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div>
 
−
----
 
−
<div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div>
 
−
----
 
−
<div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div>
 
−
----
 
−
<div id="2SpaceContent" class="zcontent" align="left">
 
  
 
{| id="TABLE3" class="SpreadSheet blue"
 
{| id="TABLE3" class="SpreadSheet blue"
 
|- class="even"
 
|- class="even"
−
| class=" " |
+
| class=" " | '''Function'''
−
| Column1
+
| class="  " | '''Output'''
−
| class="  " | Column2
+
 
−
| Column3
 
−
| Column4
 
 
|- class="odd"
 
|- class="odd"
−
| class=" " | Row1
+
| class="sshl_f" |DOLLARDE(1.11,18)
−
| class="sshl_f" | 1.11
+
| class="sshl_f" |1.6111111111111116
−
| class="sshl_f" | 18
+
 
−
| class="                                         sshl_f " |
 
−
| class=" " |
 
 
|- class="even"
 
|- class="even"
−
| class="  " | Row2
+
| class="sshl_f" |DOLLARDE(10.0,16)
−
| class="sshl_f" | 1.6111
+
| class="sshl_f" |10
−
| class="                                                           sshl_f " |
+
 
−
| class=" " |
 
−
| class=" " |
 
−
|- class="odd"
 
−
| Row3
 
−
| class="                                                                                                                                                                                  " |
 
−
| class=" " |
 
−
| class=" " |
 
−
| class=" " |
 
−
|- class="even"
 
−
| Row4
 
−
| class=" " |
 
−
| class=" " |
 
−
| class=" " |
 
−
| class=" " |
 
 
|- class="odd"
 
|- class="odd"
−
| class=" " | Row5
+
| class="sshl_f" |DOLLARDE(3.1,20)
−
| class=" " |
+
| class="sshl_f" |3.5000000000000004
−
| class=" " |
 
−
| class=" " |
 
−
| class=" " |
 
−
|- class="even"
 
−
| Row6
 
−
| class=" " |
 
−
| class=" " |
 
−
| class=" " |
 
−
| class=" SelectTD  SelectTD" |
 
−
<div id="2Space_Handle" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
 
 
|}
 
|}
  
−
<div align="left">[[Image:calci1.gif]]</div></div>
+
==Related Videos==
−
----
+
 
 +
{{#ev:youtube|-RpZ3IduCN0|280|center|DOLLARDE}}
 +
 
 +
== See Also ==
 +
 
 +
*[[Manuals/calci/DOLLARFR | DOLLARFR]]
 +
*[[Manuals/calci/DOLLAR | DOLLAR]]
 +
 
 +
==References==
 +
 
 +
*[http://en.wikipedia.org/wiki/Dollar Dollar]
 +
 
 +
 
 +
*[[Z_API_Functions | List of Main Z Functions]]
 +
 
 +
*[[ Z3 |  Z3 home ]]

Latest revision as of 17: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


Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/DOLLARDE&oldid=211163"