Why advanced components reduce design debt in Figma - Formula Trace Breakdown

Sample Data

This data shows different UI components, how many times they are used, and their impact on design debt. Basic components cause high design debt, advanced components cause low design debt.

Cell	Value
A1	Component Name
B1	Usage Count
C1	Design Debt Impact
A2	Basic Button
B2	50
C2	High
A3	Advanced Button
B3	50
C3	Low
A4	Basic Card
B4	30
C4	High
A5	Advanced Card
B5	30
C5	Low

Formula Trace

IF(C2="High", "Reduce design debt by using advanced components", "Design debt is low")

Step 1: C2 = "High"

Step 2: IF(true, "Reduce design debt by using advanced components", "Design debt is low")

Cell Reference Map

    A          B          C
1 |Component |Usage Count|Design Debt|
2 |Basic Button |    50    |   High   |
3 |Advanced Button   |    50    |   Low    |
4 |Basic Card|    30    |   High   |
5 |Advanced Card  |    30    |   Low    |

The formula references cell C2 to check the design debt impact of the Basic Button component.

Result

    A          B          C          D
1 |Component |Usage Count|Design Debt|Advice
2 |Basic Button |    50    |   High   |Reduce design debt by using advanced components

The formula result in column D advises to reduce design debt by using advanced components when design debt is high.

Sheet Trace Quiz - 3 Questions

What does the formula check in cell C2?

A If usage count is 50

B If design debt is High

C If component name is Basic Button

D If design debt is Low

Key Result

IF(condition, value_if_true, value_if_false) returns different advice based on design debt level