Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

String formatting

Topic Labels: Formulas
Solved
Jump to Solution
287 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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?

1 Solution

Accepted Solutions

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

See Solution in Thread

2 Replies 2

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

That worked perfectly

Thanks