A price grid with mixed references

Premium
Step 1 of 3

E2:G4 should show what each item costs for 10, 50 and 100 units. Every cell multiplies a price from column B by a number of units from row 1.

Click Continue when you're ready.

Already know it? Type the formula straight into E2.

E2
ABCDEFGH
1Item Price Units 10 50 100
2Pens 4
3Notebooks 12
4Folders 7
5
6
7
8

Premium lesson

Unlock Relative and absolute references and every other lesson

This is a premium lesson. Premium lets you solve it and every other lesson, take the timed mock tests, and earn certificates you can share on LinkedIn.

Next with premium:PercentagesIF

Your first month for $9.50 $19

50% off your first month when you join today.

Get your first month for $9.50

Then $19/month. Cancel any time, and get a full refund within 14 days if it isn't for you.

Already premium? Sign in
Need help?