InterviewLegend

Spreadsheet Formulas & Dependent Cells

Alex Chen45 min readGuide updated

Ramp's spreadsheet question has stayed in rotation for years. You build a small spreadsheet in code. Cells hold numbers or text, some hold formulas that read other cells, and when a cell changes, everything that reads it has to show the new value. A Staff candidate in September 2024 described the round as a spreadsheet "with basic functionality" and summed up the difficulty in two words, "No tricks."

In 2026 it came up twice. A July technical screen asked about cell dependencies, recalculation order and cycle handling. A September onsite was built on string cells, with concatenation formulas and circular-reference errors that appear when you read a cell. The fullest descriptions are older, from 2024 to spring 2025: a frontend screen in January 2024, senior onsites in March and May 2024, the Staff onsite that September and two phone screens in spring 2025.

The problems below run newest first. The string sheet leads, then the version that recomputes dependents on every write, then the 2024 numbers-and-ranges version, which sits closest to LeetCode 631, Design Excel Sum Formula. Frontend candidates build the same thing as a React UI, covered at the end with the formula parser it needs. If you've never built one, start with the third problem. It's the gentlest.

The Ramp angle
Get set and get working on plain values before you touch formulas. "No tricks" is a fair summary of this round. The points come from a clean model you can extend. Keep raw input apart from computed values, know your dependency graph well enough to explain it, and make sure a cycle never hangs.

RampPremium lesson · Coding round

The 4 Ramp problems are below.

  1. A Premium questionCoding · Medium
  2. A Premium questionCoding · Hard
  3. A Premium questionCoding · Medium

+ 1 more in this lesson

Each with hints, the follow-up and a tested solution.

Get the Ramp questions

$49 a year · all 107 companies · instant access

20,000+ candidate reports

Ramp interview guide

Know what Ramp asks before you walk in.

29 coding · 3 system design · 18 behavioral questions

Get Premium$49 a year · Instant access
Or start freeNo card.

Get their questions first.

Had your Ramp interview?How we research

InterviewLegend is independent and not affiliated with or endorsed by any company it covers.