nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Formula - Yes, no, n/a

CommunityMember113484

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".

Thanks in advance

Accepted answers

jackcplanning

Hi @CommunityMember113484 ,

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.

All comments

jackcplanning

Hi @CommunityMember113484 ,

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.

SandeepB

@CommunityMember113484 ,

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

CommunityMember113484

Thanks, worked great!

Quick Links

Can you help?

Unanswered questions

Integration Process Execution Access - Which Access Takes Precedence?
We have an Integration Process in Anaplan CloudWorks created by User X - No WSA (originally Full Access with top-level Selective Access, now changed to Planner Read Only with Selective Access unchanged) and scheduled by User Y - with WSA , who also created the Integration Flow. Internal (Full Access) is enabled within the…
Anaplan XL Forms Error
Does anyone also get this error when opening the Forms in Anaplan FCR? I am downloading Investment Registry from the app but I cannot open it in Anaplan XL. How did you fix this issue?
Anaplan ⇄ Google Sheets pivot tool — feedback welcome
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…