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)))))
)
)
)
)
)
)
Improve this question

1 Answer 1

Reset to default
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)
                  )
                )
           )
       )
  )
Improve this answer
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
    Jun 8, 2017 at 23:24
  • remove entire formula and try to add one by one condition in the formula
    – Santanu Boral
    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
    Jun 9, 2017 at 22:53

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.