"IF" Field Calculation Help

Question

Hi All, was hoping to get a little insight into why a portion of my IF formula is populating. WF accepts the code I created, however when the reference field has a score of 100, the formula I created doesn't display the text that should be displayed from the calculation, "Active Dev. Up To Date"

Here's my current calculation.

IF({DE:AD Completion Score}<50,"Active Dev. Less Than 50%",IF({DE:AD Completion Score}>50,"Active Dev. 50% Complete",IF({DE:AD Completion Score}=100,"Active Dev. Up To Date")))

Sven-iX · Answer

Hi @omahaomaha

I like Skye's suggestion of starting with the =100.

As she pointed out, if you're never reaching the third condition because if the number is greater than 50, it ends with the second condition.

Funnily your condition makes it so that if the completion score is 50 - the calculation shows N/A (because there's no condition).
You can use 2 conditions to fix this

is Active Dev = 100?
is Active Dev > 50

IF(
    {DE:AD Completion Score}=100,
    "Active Dev. Up To Date",
    IF(
        {DE:AD Completion Score}>=50,
        "Active Dev. 50% Complete",
        "Active Dev. Less Than 50%"
    )
)

Sign up

Login with SSO

Login to the community

Login with SSO