Thanks @skyehansen , I think that's the nudge that did the trick! I re-wrote my code as follows:IF(DIV({workRequired},60)<=25,"Tier 3",IF(DIV({workRequired},60)<=50,"Tier 2",IF(DIV({workRequired},60)<=100,"Tier 1",IF(DIV({workRequired},60)>=101,"Tier 1","Tier 1")))) And now each project that the cus...