Using TEXT function to change formula into dollar amount

Platform discussions
1

I am trying to change a cell into a $ dollar amount. I’ve been trying to use the TEXT function for a simple divide or multiple formula such as: {Event Cost}-{Chargeback Income}.

However, when I try to use the TEST function suggestion from other forums I keep getting errors? Any insight/suggestions?

2

Hi April,

Try:

TEXT({Event Cost}-{Chargeback Income},"$#,##0.00")

Want to take your formulas to the next level? Try the Advanced Formula Booster, the app that reinvents formulas in monday.

  • Create formulas without using the Formula column (and avoid its limitations)
  • Build formulas involving data from the previous item, the next item, the sub-items, the parent item, even items in the same group or the same board.
  • In one formula, update multiple columns from multiple items.

Check our blog for real use cases.