0

I'm working on a custom formula but I'm getting a syntax error and I can't figure out the error. Essentially what I'm trying to do is a sign a value to a custom field based on amount? Thank you for your help in advance for your help. We want to be able to show $0 if $0 is entered. My formula is below:

IF(X > $1,000, "$5",
IF(X > $500, "$4",
IF(X > $100,"$3",
IF(X > $10, "$2",
IF(X > $1,"$1",
IF(X > $0,"$0", Null)))))
)
)
)
)
)
)

1 Answer 1

0

Hopefully, your formula will be like this:

IF(X > $1,000, "$5",
      IF(X > $500, "$4",
          IF(X > $100,000,"$3",
              IF(X > $10, "$2",
                  IF(X > $1,"$1",
                     IF(X < $1,"$0", Null)
                  )
                )
           )
       )
  )
3
  • Thank you Santanu, I can see your formula makes sense however after adjustment I'm getting a " Field $1 does not exist. Check spelling." error now.
    – Xperez
    Commented Jun 8, 2017 at 23:24
  • remove entire formula and try to add one by one condition in the formula Commented Jun 8, 2017 at 23:29
  • @Xperez -- is X a currency field? if yes, remove the formatting from the comparands - also, shouldn't the third if be $100; what if x = $1 ?
    – cropredy
    Commented Jun 9, 2017 at 22:53

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .