The weighted average maturity, or WAM, of one of these securities is the average number of months until the loans are paid off. A higher WAM means that you can expect to receive payments for a longer period of time than a lower WAM indicates.
No worries. Itâs easy to change it back. To change from the R1C1 cell reference style back to to the A1 style, we will change a setting in the options. Click the âFileâ tab. On the backstage screen, click âOptionsâ in the list of items on the left.On the âExcel Optionsâ dialog box, click âFormulasâ in the list of items on the left.In the âWorking with formulasâ section, select the âR1C1 reference styleâ check box so there is NO check mark in the box. Click âOKâ to accept the change and close the âExcel Optionsâ dialog box.n the backstage screen, click âOptionsâ in the list of items on the left. On the âExcel Optionsâ dialog box, click âFormulasâ in the list of items on the left. In the âWorking with formulasâ section, select the âR1C1 reference styleâ check box so there is NO check mark in the box.
You can edit your first post in this thread and change Word to Excel. In Excel: select the cell or cells that you want to format. On the Home tab of the ribbon, click Conditional Formatting. Perhaps there is something you like among the Color Scales or Icon Sets. Otherwise, click Manage Rules... Click New Rule...Select Format only cells that contain.lick Format... Specify green as fill color, then click OK twice. Click New Rule... Select Format only cells that contain. Select Cell Value from the first dropdown, less than from the second dropdown, and enter 50% in the box next to it.