Changes

Manuals/calci/PRICE (view source)

Revision as of 01:57, 9 December 2013

276 bytes removed , 01:57, 9 December 2013

no edit summary

Line 54: Line 54:

{| id="TABLE3" class="SpreadSheet blue"

|- class="even"

−

| class=" " |

+

| class="sshl_f" | 2/2/2008

−

~~| Column1~~

+

| class="sshl_f" |

−

| class="sshl_f" | ~~Column2~~

+

−

~~| Column3~~

−

~~| Column4~~

|- class="odd"

−

| class=" " | ~~Row1~~

+

| class="sshl_f" | 11/2/2016

−

~~| class=" " | 2~~/2/~~2008~~

+

| class="sshl_f" |

−

| class="sshl_f " ~~| 1~~

+

−

|

−

|

|- class="even"

−

| class=" " | ~~Row2~~

+

| class="sshl_f" | 5%

−

~~| class=" " | 11/2/2008~~

+

| class="sshl_f" |

−

| class="sshl_f" | ~~97.852841~~

+

−

|

−

|

|- class="odd"

−

~~| Row3~~

+

| class="sshl_f" | 8%

−

| class=" " | 5%

+

| class="sshl_f" |

−

| class=" ~~SelectTD ChangeBGColor SelectTD" |~~

+

−

<div id="2Space_Handle" class="zhandles" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" class="zhandles" title="Click and Drag over to AutoFill other cells."></div><div id="2Space_Drag" class="zhandles" ~~title="Click and Drag to Move/Copy Area.">[[Image:copy-cube.gif]] </div>~~

−

|

−

|

|- class="even"

−

~~| Row4~~

+

| class="sshl_f" | $100

−

| class=" " | 8%

+

| class="sshl_f" |

−

|

−

|

|- class="odd"

−

| class=" " | ~~Row5~~

+

| class="sshl_f" | 2

−

| class=" " | ~~100~~

+

| class="sshl_f" |

−

|

+

−

|

−

|

|- class="even"

−

~~| Row6~~

+

| class="sshl_f" | 0

−

| class=" " | 2

+

| class="sshl_f" |

−

|

−

|

−

|

|}

+

=PRICE(A1,A2,A3,A4,A5,A6,A7) : Calculates the Price Value with the inputs in the range A1 to A7. Returns ''81.36538958112115''.

== See Also ==

Swapna

writer

2,661

edits