Skip to main content
Solved

IF Statement syntax

  • February 9, 2023
  • 5 replies
  • 36 views
D
Forum|alt.badge.img+1

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)

Best answer by Matt_Boudreau

hmm, still says invalid


*you have a parenthisis at the wrong spot, that this snippet:
 
IF(VALUE({Total Rate 6}) >0, VALUE({Total Rate 6}), "")

5 replies

M
Forum|alt.badge.img+5

just use this "" for the else portion.

D
Forum|alt.badge.img+1
  • dpnetwork
  • Author
  • New Participant
  • February 9, 2023

hmm, still says invalid

M
Forum|alt.badge.img+5
  • Matt_Boudreau
  • Inspiring
  • Answer
  • February 9, 2023

hmm, still says invalid


*you have a parenthisis at the wrong spot, that this snippet:
 
IF(VALUE({Total Rate 6}) >0, VALUE({Total Rate 6}), "")
W
D
Forum|alt.badge.img+1
  • dpnetwork
  • Author
  • New Participant
  • February 9, 2023

Thank you!!! that worked

Ben_Young1
Forum|alt.badge.img+22
  • Ben_Young1
  • Brainy
  • February 9, 2023

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.

Terms & ConditionsAccessibility statement