If you would add a currency symbol with a formula, the entire cell would be text and therefore you would no longer be able to calculate with the number in the cell. The way you add a currency symbol to a number, is by applying the 'accounting format' to a cell. You can see an example in this video: ruclips.net/video/rodTvDX9h08/видео.html
What's the formula if you add currency symbol before the total?
If you would add a currency symbol with a formula, the entire cell would be text and therefore you would no longer be able to calculate with the number in the cell.
The way you add a currency symbol to a number, is by applying the 'accounting format' to a cell. You can see an example in this video: ruclips.net/video/rodTvDX9h08/видео.html