"IF" Field Calculation Help

[OmahaOmaha]

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

[skyehansen]

If I had to guess, I would say the reason that the last part (100) isn't being read is because 100 is greater than 50%.So it is fulfilling the middle part of your statement ("50% complete") and doesn't get a chance to get all the way to what to do if it's 100% complete.

You could try to reverse the entire thing. "IF 100% do X, if >50 do Y, if <50 do Z". Or maybe just change the middle part of the statement to IF <100 instead of IF >50.

[Sven-iX]

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

1. is Active Dev = 100?
2. 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%"
    )
)