Hello @aecross try this:

=IF(

 AND([OVERALL TIER]@row = "Tier I", [PARTNER]@row = "TB", [CDs]@row = "SK"),

 100,

 IF(

  AND([OVERALL TIER]@row = "Tier II", [PARTNER]@row = "TB", [CDs]@row = "SK"),

  90,

  "Other value"

 )

)

In this formula, the first condition checks if the overall tier is "Tier I", the partner is "TB", and the CDs are "SK". If all these conditions are true, it returns the value 100. Otherwise, it moves on to the next condition.

The second condition checks if the overall tier is "Tier II", the partner is "TB", and the CDs are "SK". If these conditions are true, it returns the value 90. If none of the conditions match, you can specify the desired outcome for other scenarios by replacing "Other value" with the appropriate value or expression.

You can continue adding more conditions by extending the formula within the nested IF statements.

HTH!