## Formula - Yes, no, n/a

Occasional Contributor

## Formula - Yes, no, n/a

Hi,

How do I build a formula which states if a = b, then "not required", if a > b, then "yes", and if a < b, then "no".

1 ACCEPTED SOLUTION

Accepted Solutions
Certified Master Anaplanner

A simple IF statement may be what you're looking for:

IF a = b THEN "not required" ELSE IF a > b THEN "yes" ELSE "no"

Please keep in mind, to optimize the formula, place the earliest exit first.

3 REPLIES 3
Certified Master Anaplanner

A simple IF statement may be what you're looking for:

IF a = b THEN "not required" ELSE IF a > b THEN "yes" ELSE "no"

Please keep in mind, to optimize the formula, place the earliest exit first.

Occasional Contributor
Thanks, worked great!
Regular Contributor

There are several ways you can technically achieve this.

However, I would like to understand what is "a" and "b" in your statement?

Number formatted line items without any dimensions? if so, your formula looks something like this: if a=b then "not required"(text formatted line item) else if a>b then "yes" else "no"

Let me know if that helps.

Thanks,

Sandeep