# Including a comma for currency within an existing formula

There are two columns with formulas that I am looking to incorporate adding not only a dollar sign (\$) but also a comma (,) to properly represent US currency.

• The LVL or Level column represents a current level. Each level has a different threshold requirement that must be met for both Current LO MRR\$ and Progress to LO MRR\$.
• The LO MRR\$ column is the current total which is referenced in the formula for both Current LO MRR\$ and Progress to LO MRR\$ columns. The cells in the LO MRR\$ column are linked to cells in another sheet and are auto populated per weekly updates.
• The formulas for Current LO MRR\$ and Progress to LO MRR\$ columns are very similar in their function. The Current LO MRR\$ column compared the LO MRR\$ to the threshold of the current LVL, whereas the Progress to LO MRR\$ column compares the LO MRR\$ to the threshold requirements of the next LVL in order to progress.

As you can see from the example below the currency from the LO MRR\$ column is currently being represented as a straight numerical value with a preceding dollar sign (\$) in both the Current LO MRR\$ and Progress to LO MRR\$ columns.

I am hoping there is a way to adjust the formula so that what is represented is currency rather than just a numerical response. Example: \$12,119 of \$1,500

The formula below is from the Current LO MRR\$ column. Is there any adjustments that can be made to accomplish this?

=IF([LO MRR\$]@row <> "", "\$" + [LO MRR\$]@row + " of " + IF(LVL@row = 1, "\$0", IF(LVL@row = 2, "\$1,500", IF(LVL@row = 3, "\$10,000", IF(LVL@row = 4, "\$10,000", IF(LVL@row = 5, "\$50,000"))))))