what is yield formula in excel?
The Excel YIELD function returns the yield on a security that pays periodic interest. Get yield for security that pays periodic interest. Yield as percentage. =YIELD (sd, md, rate, pr, redemption, frequency, [basis]) sd - Settlement date of the security.