Sets the maximum number of iterations used for goal seeking or for resolving circular references based on the number you type in the Maximum Iterations box. Accepts: whole numbers from 1 through 32767.
Sets options for how your Excel data will look when the data is viewed in a web browser. Affects: only the active workbook. ...
Sets the Custom Lists available. Click a list that you want to edit, or click NEW LIST in the Custom Lists box to create ...
Sets the default format for saved files and other compatibility options. This makes it easier to share Excel workbooks with ...
Sets the maximum amount of change below which iteration stops for goal seeking or for resolving circular references based ...
Sets the maximum number of iterations used for goal seeking or for resolving circular references based on the number you ...
Sets the preferred file type Excel uses when you save workbooks. If your workbooks are used in different versions of Excel, ...
settlement,maturity,coupon,yld,frequency,basis!Returns the annual duration of a security with periodic interest payments!is ...
settlement,maturity,coupon,yld,frequency,basis!Returns the Macauley modified duration for a security with an assumed par ...
settlement,maturity,discount!Returns the bond-equivalent yield for a treasury bill!is the Treasury bill's settlement date, ...