Sign Up ›
  • Laura Cole 7
  • NEWBIE
  • 0 Points
  • Member since 2021
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 1
    Replies
3 replies

How to nest a formula with a formula (If/And Statement)

Here's my formula need.

IF(Field A > (Field B * 1.1)), "ERROR", 

AND/OR

IF((Field C * 12 / Field A) < Field D, "Error",

Otherwise it should calulate and post

(Field C * 12) / Field A

How would I represent this? I've tried several methods. Also, tried doing a validation but the field itself isn't showing up in the validation field options when I create it.
3 replies

How to nest a formula with a formula (If/And Statement)

Here's my formula need.

IF(Field A > (Field B * 1.1)), "ERROR", 

AND/OR

IF((Field C * 12 / Field A) < Field D, "Error",

Otherwise it should calulate and post

(Field C * 12) / Field A

How would I represent this? I've tried several methods. Also, tried doing a validation but the field itself isn't showing up in the validation field options when I create it.