As you select a different lender, you get different values for things like annual percentage rate, the percentage of equity you can borrow against, and the number of loan years. In a more involved example, you could set up a scenarios list that lets you choose among names of different home equity lenders. That cell, in turn, is used in formulas elsewhere in the spreadsheet so when you select a different percentage rate from the drop-down list, the values in the spreadsheet adjust automatically. In its fullest form, it lets you enclose a set group of cells whose contents change when you select a different item from the drop-down list.įor example, you could set up a scenarios list that lets you choose among different percentage rates for a cell. In its simplest form, it lets you create a drop-down list of values to select from for a given cell. Calc's scenarios tool is one of the coolest features any spreadsheet application could provide.
0 kommentar(er)
