Spreadsheet Formulas & Dependent Cells
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.
RampPremium lesson · Coding round
The 4 Ramp problems are below.
- A Premium questionCoding · Medium
- A Premium questionCoding · Hard
- 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 guideKnow what Ramp asks before you walk in.
29 coding · 3 system design · 18 behavioral questions
Get their questions first.
InterviewLegend is independent and not affiliated with or endorsed by any company it covers.