Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

IF Statement syntax

Topic Labels: Formulas
Solved
Jump to Solution
2216 5
cancel
Showing results for 
Search instead for 
Did you mean: 
dpnetwork
4 - Data Explorer
4 - Data Explorer

Hello, maybe this is not even possible, but if it is, what would be the proper syntax for this ?

IF(VALUE({Total Rate 6})) >0, VALUE({Total Rate 6}), Blank()
 
This field is showing the data of another column called "Total Rate 6", but i want it to be blank if the amount is 0(zero)
1 Solution

Accepted Solutions
Matt_Boudreau
5 - Automation Enthusiast
5 - Automation Enthusiast
*you have a parenthisis at the wrong spot, that this snippet:
 
IF(VALUE({Total Rate 6}) >0, VALUE({Total Rate 6}), "")

See Solution in Thread

5 Replies 5
Matt_Boudreau
5 - Automation Enthusiast
5 - Automation Enthusiast

just use this "" for the else portion.

dpnetwork
4 - Data Explorer
4 - Data Explorer

hmm, still says invalid

Matt_Boudreau
5 - Automation Enthusiast
5 - Automation Enthusiast
*you have a parenthisis at the wrong spot, that this snippet:
 
IF(VALUE({Total Rate 6}) >0, VALUE({Total Rate 6}), "")
dpnetwork
4 - Data Explorer
4 - Data Explorer

Thank you!!! that worked

Ben_Young1
11 - Venus
11 - Venus

Hey @dpnetwork

Here's your original formula:

IF(
    VALUE({Total Rate 6})) > 0,
    VALUE({Total Rate 6}),
    Blank()
)

The first VALUE() function has a trailing open parentheses hanging on the end of it. The second syntax violation is the "Blank()" function. Whenever you invoke a function, you'll want to be sure to capitalize the function.

Here are a few syntax valid versions and permutations of your formula:

IF(
    VALUE({Total Rate 6}),
    VALUE({Total Rate 6})
)
IF(
    {Total Rate 6},
    {Total Rate 6}
)
IF(
    {Total Rate 6},
    {Total Rate 6},
    ""
)

I have historically found that the BLANK() function isn't always predictable. It generally doesn't have much usage in practice besides maybe making beefier formulas a bit more readable, but even then, they can make debugging a large formula rather difficult at times.