+2IF({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?
Best answer by Kamille_Parks11
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})
+27The 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})
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.