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.…