| Line 18: |
Line 18: |
| | ==Examples== | | ==Examples== |
| | | | |
| − | {| id="TABLE2" class="SpreadSheet blue" | + | {| class="wikitable" |
| − | |- class="even" | + | |- |
| − | | class=" " |
| + | ! !! A !! B |
| − | | class=" " | Column1
| + | |- |
| − | | class=" " | Column2
| + | ! 1 |
| − | | Column3
| + | | -12000 || 02-01-2009 |
| − | | Column4
| + | |- |
| − | |- class="odd" | + | ! 2 |
| − | | class=" " | Row1
| + | | 3000 || 04-01-2009 |
| − | | class="sshl_f " | -10000
| + | |- |
| − | | class="sshl_f " | 02-01-2009 | + | !3 |
| − | | class=" sshl_f " | 2069.5268
| + | | 4300 || 11-30-2009 |
| − | | class=" sshl_f " |
| + | |- |
| − | |- class="even" | + | ! 4 |
| − | | class=" " | Row2
| + | | 3250 || 03-15-2010 |
| − | | class="sshl_f" | 3000
| + | |- |
| − | | class="sshl_f " | 04-01-2009 | + | ! 5 |
| − | | class=" " |
| + | | 2200 || 5-1-2010 |
| − | | class=" " |
| |
| − | |- class="odd" | |
| − | | Row3
| |
| − | | class="sshl_f" | 4300
| |
| − | | class="sshl_f" | 11-30-2009 | |
| − | | class=" " |
| |
| − | | class=" " |
| |
| − | |- class="even" | |
| − | | Row4
| |
| − | | class="sshl_f" | 3250
| |
| − | | class=" " | 03-15-2010 | |
| − | | class=" " |
| |
| − | | class=" " |
| |
| − | |- class="odd" | |
| − | | class=" " | Row5
| |
| − | | class=" " | 2200
| |
| − | | class=" " | 05-01-2010 | |
| − | | class=" " |
| |
| − | | class=" " |
| |
| − | |- class="even"
| |
| − | | class="sshl_f" | Row6
| |
| − | | class=" sshl_f " |
| |
| − | | class=" " |
| |
| − | | class=" " |
| |
| − | | class="sshl_f " |
| |
| − | |- class="odd"
| |
| − | | class="sshl_f " | Row7
| |
| − | | class=" " |
| |
| − | | class=" sshl_f SelectTD SelectTD" |
| |
| − | <div id="9Space_Handle" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="9Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
| |
| − | |
| |
| − | |
| |
| | |} | | |} |
| | + | =XNPV(0.95,A1:A5,B1:B5)= -4330.389965454265 |
| | | | |
| | ==See Also== | | ==See Also== |
| | ==References== | | ==References== |