String formatting

[Michael_Arsenau]

IF({amount of discount}=0," ",IF({amount of discount}<0,{amount of discount}))

I got this to do what I want - only show a value on a sales receipt if the value is <0

The problem is that the answer is considered a string answer and I cannot format it to display as currency. All fields leading into this formula are numbers (formatted currency) I want the results to be displayed as currency.

Suggestions?

[Kamille_Parks · Accepted solution]

The outcome is considered a string because a possible value based on your formula is a space character, instead of BLANK(). You could simplify your formula to just be your nested IF statement, which should fix your formatting trouble.

IF({amount of discount}<0, {amount of discount})

[Michael_Arsenau]

That worked perfectly

Thanks