Excel Office

Excel How Tos, Tutorials, Tips & Tricks, Shortcuts

Tag: YIELD function

YIELD function: Description, Usage, Syntax, Examples and Explanation

What is YIELD function in Excel? YIELD function is one of Financial functions in Microsoft Excel that returns the yield on a security that pays periodic interest. Use YIELD to calculate bond yield. Syntax of YIELD function YIELD(settlement, maturity, rate, pr, redemption, frequency, [basis]) Important: Dates should be entered by using the DATE function, or as results of other formulas or functions.…