Skip to main content
Solved

Convert Formula result to a currency amount

  • July 4, 2021
  • 2 replies
  • 34 views

so this is my current Formula - IF({Sold Platform}=“GOAT”,{Unit Sold Price}-({Unit Sold Price}*.095)-5,"")

I am trying to have this result in a $dollar amount. I’ve looked through the community pages but I’m struggling to get the desired result. Can anyone help?

Best answer by ScottWorld

Get rid of the final comma and empty quotation marks.

Alternatively, change the final quotation marks to the number 0.

2 replies

ScottWorld
Forum|alt.badge.img+35
  • Genius
  • Answer
  • July 4, 2021

Get rid of the final comma and empty quotation marks.

Alternatively, change the final quotation marks to the number 0.


Get rid of the final comma and empty quotation marks.

Alternatively, change the final quotation marks to the number 0.


Perfect! thanks so much!