![]() Can a formula be applied to all cells in a column? You now grab the little square on the bottom right of the highlighted area and drag that down, across or both. If you want to extend your range down you can do this by calculating the first 2 cells with your formula and then highlighting them. Check that the sheet and cells that are showing the formula aren’t protected. Update: noticed that if I let the autocomplete fill in the rest of function name (such as, I write conc. How to show formula instead of result in Excel? Press Shift+Ctrl+V to open the Paste Special dialog box. While the column C is still highlighted, press Ctrl+C to copy all selected cells to the clipboard. How do you duplicate cells in openoffice? the formula is = prin * POWER((1 + rate ) nper), e.g. ![]() nper, the number of periods over which interest is compounded, e.g. Prin, the principal of the loan at the start of the first period, e.g. ![]() How do you calculate simple interest in Open Office Calc? ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |