The most common reason for this is that the cell isn’t wide enough to display the full contents.
The quick, easy way to increase the width of the cell is to double click on the column line after the cell within the header row. It will increase not only that cell, but the entire column.
Rolling dice, flipping coins, drawing cards or straws, drawing slips of paper out of a hat. All methods to generate random results. Here’s one more:
To Create a Random Number: In a blank cell of any spreadsheet program, type @randbetween(x,y) where x equals the smallest number you want to use and y equals the largest. In other words, typing the function @randbetween(1,100) will generate a number between 1 and 100.
Recalculate the Number: Press the “F9” key to generate a new number.
Change a Random Number to a Value: Note that any time you make a change to any cell in your spreadsheet, the program recalculates all the formulas on the sheet. That means the random number will recalculate every time a change is made to the spreadsheet. If you want to make your random value permanent, move to the cell with your @RANDBETWEEN function and press F2 (EDIT), then F9 (CALC).
Compatibility: This formula will work in Excel, Quattro Pro and Lotus 123. Have a different spreadsheet program? Give it a shot.
Microsoft Purists: Some of you may be thinking that Excel formulas begin with an equal sign, so the formula should be: “=randbetween(1,100)” True enough. Go ahead. But I’ve been using spreadsheet software for a long time (Lotus 123). We old timers know that spreadsheet formulas are “supposed” to begin with “@” and we also know that formulas beginning with an equal sign won’t work in Quattro Pro and Lotus. Because Microsoft is special.
Check out Quattro Pro, Corel’s spreadsheet program! And yes. Excel has amortization templates and maybe I will blog about them – but not it is not this day! (I just watched Return of the King) With Quattro, this is WAY too easy! Check it out!
(In Quattro 9, 10, 11 and 12) From the menu, select Tools, Numeric Tools, and then Analysis Tools. The second item is Amortization Schedule. Select it and a dialog box will be displayed:
Output Cells: This automatically fills in, so leave it & see if it works for you before you modify it.
Interest Rate: you know what to do.
Term: (years): yet again, you are smart – go for it.
Original: Enter the original loan amount.
Ending Balance: what? I’m thinking zero?
Last Year: Enter last year you need to see.
Choose “Finish” and in a FLASH, you see your results!