writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 73:
Line 73: − +
no edit summary
=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(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.
=YIELDMAT(DATE(2007,1,1), DATE(2008,2,20), DATE(2006,10,15), "5%", 100) : Calculates the percentage annual yield with the inputs. <br />Returns '''4.95%''' as a result.
== See Also ==
== See Also ==