Changes

Manuals/calci/YIELDMAT (view source)

Revision as of 12:31, 4 February 2014

165 bytes added , 12:31, 4 February 2014

no edit summary

Line 72: Line 72:

=YIELDMAT(A1,A2,A3,A4,A5,A6) : Calculates the percentage annual yield with the inputs in the range A1 to A6. Returns '''5.47%''' as a result.

+

=YIELDMAT(DATE(2007,1,1), DATE(2008,2,20), DATE(2006,10,15), "5%", 100) : Calculates the percentage annual yield with the inputs. Returns '''4.95%''' as a result.

== See Also ==

Swapna

writer

2,661

edits