When you only need two outcomes, the IF function is fine. But the moment you start stacking conditions (if this, then that, otherwise if this, then that), you’re building a house of cards. At first, ...
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 ...