Array constants can only contain text in double quotes, plain numbers (no currency symbols or percent signs), or Boolean ...
To apply the dollar currency to a value, select the cell, press Ctrl+1 to launch the Format Cells dialog box, and select "Currency" or "Accounting" in the Number tab. Then, choose the dollar symbol ...
An annuity is a financial product that provides a stream of income over a set period. Annuities are often used in retirement planning as a way to generate income from a lump sum investment.