Excel Study · Module 1: First steps
Class 7Absolute references: the $ sign
Basics1:46 videoFree
Copy =B2*E2 down and it breaks: the next row asks for E3, which is empty. Lock the rate cell with dollar signs, =B2*$E$2, and every row uses E2. Press F4 right after typing the reference (Cmd + T on a Mac) to add the dollars.
Try this AI prompt
Works in ChatGPT, Gemini, Copilot or Claude.
In Excel, prices are in B2 to B6 and the tax rate is in cell E2. Write a formula for C2 that works out the tax amount on the price in B2, that I can drag down to C6, and that always uses the rate in E2.
The answer that works
✓ checked in Excel=B2*$E$2
AI can get Excel wrong. Paste its answer into Excel and test it before you trust it.