String formatting

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?

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})

2 Likes

That worked perfectly

Thanks

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.