Rectangle and ellipse tools in Figma - Cell-by-Cell Formula Trace

Sample Data

This data shows two shapes created with Figma's rectangle and ellipse tools, with their width and height dimensions.

Cell	Value
A1	Shape
B1	Width
C1	Height
D1	Area
A2	Rectangle
B2	10
C2	5
A3	Ellipse
B3	10
C3	5

Formula Trace

IF(A2="Rectangle", B2*C2, PI()*B3*C3/4)

Step 1: A2="Rectangle"

Step 2: B2*C2

Step 3: IF(TRUE, 50, PI()*B3*C3/4)

Cell Reference Map

    A       B       C       D
1 | Shape | Width | Height | Area
2 |Rectangle|  10  |   5   |  ?  
3 | Ellipse |  10  |   5   |     

The formula references cells A2, B2, C2 for rectangle area calculation and B3, C3 for ellipse area if needed.

Result

    A       B       C       D
1 | Shape | Width | Height | Area
2 |Rectangle|  10  |   5   |  50 
3 | Ellipse |  10  |   5   |     

The area for the rectangle is calculated as 50 and displayed in cell D2.

Sheet Trace Quiz - 3 Questions

What does the formula check first?

A If the width is greater than height

B If the shape is a rectangle

C If the shape is an ellipse

D If the area is already calculated

Key Result

IF(shape = "Rectangle", width * height, PI() * width * height / 4) calculates area for rectangle or ellipse.