Difference between revisions of "Manuals/calci/DOLLARFR"

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">'''DOLLARFR'''</font><font size="2">(</font><fo...")
 
Line 1: Line 1:
<div id="6SpaceContent" class="zcontent" align="left"> 
+
=DOLLARFR(DD, Fraction)=
  
<font color="#000000"><font face="Arial, sans-serif"><font size="2">'''DOLLARFR'''</font><font size="2">(</font><font size="2">'''DD'''</font><font size="2">, </font><font size="2">'''F'''</font><font size="2">)</font></font></font>
+
where,
 +
*<math>DD</math> is a dollar value in decimal
 +
*<math>Fraction</math> is the integer to use as a denominator
  
<font color="#000000"><font face="Arial, sans-serif"><font size="2">'''Where 'DD''''</font><font size="2"> is a decimal number and 'F' is the integer to use in the denominator of a fraction.</font></font></font>
+
DOLLARFR() converts a dollar price in decimal number to dollar price in fraction.
  
</div>
+
== Description ==
----
 
<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 decimal into fraction 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>
+
DOLLARFR(DD, Fraction)
  
</div>
+
*Argument <math>DD</math> is a decimal number to be converted into fraction.
----
+
*Argument <math>Fraction</math> is an integer to be used as a denominator in conversion to fractional value.
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
+
*Calci divides the fractional part of <math>DD</math> by the specified <math>Fraction</math> value.
 +
*<math>Fraction</math> should be &gt;=1, else Calci displays #ERROR message.
 +
*If <math>Fraction</math> is not an integer, it is truncated.
  
DOLLARFR
+
== Examples ==
  
</div></div>
+
<div id="6SpaceContent" class="zcontent" align="left">
----
 
<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">DOLLARFR(DD, F)</font></font></font>
 
 
 
<font color="#000000"><font face="Arial, sans-serif"><font size="2"><nowiki>=DOLLARFR(1.6111,18) is 1.11</nowiki></font></font></font>
 
 
 
</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" |DOLLARFR(1.611,18)
| class="sshl_f" | 1.6111
+
| class="sshl_f" |1.10998
| class="                     sshl_f " | 18
+
 
| class="                                                                    " |
 
| class=" " |
 
 
|- class="even"
 
|- class="even"
| class="  " | Row2
+
| class="sshl_f" |DOLLARFR(10.0,16)
| class="sshl_f" | 1.11
+
| class="sshl_f" |10
| class="                                                                             " |
+
 
| class=" " |
 
| class=" " |
 
 
|- class="odd"
 
|- class="odd"
| Row3
+
| class="sshl_f" |DOLLARFR(3.1,20)
| class="                                                                                                  " |
+
| class="sshl_f" |3.02
| class=" " |
 
| class=" " |
 
| class=" " |
 
|- class="even"
 
| Row4
 
| class=" " |
 
| class=" " |
 
| class=" " |
 
| class=" " |
 
|- class="odd"
 
| class=" " | Row5
 
| class=" " |
 
| 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>
+
== See Also ==
----
+
 
 +
*[[Manuals/calci/DOLLARDE | DOLLARDE]]
 +
*[[Manuals/calci/DOLLAR | DOLLAR]]
 +
 
 +
==References==
 +
 
 +
*[http://en.wikipedia.org/wiki/Dollar Dollar]

Revision as of 17:26, 16 January 2014

DOLLARFR(DD, Fraction)

where,

  • is a dollar value in decimal
  • is the integer to use as a denominator

DOLLARFR() converts a dollar price in decimal number to dollar price in fraction.

Description

DOLLARFR(DD, Fraction)

  • Argument is a decimal number to be converted into fraction.
  • Argument is an integer to be used as a denominator in conversion to fractional value.
  • Calci divides the fractional part of by the specified value.
  • should be >=1, else Calci displays #ERROR message.
  • If is not an integer, it is truncated.

Examples

Function Output
DOLLARFR(1.611,18) 1.10998
DOLLARFR(10.0,16) 10
DOLLARFR(3.1,20) 3.02

See Also

References