Using a vertical multiplier constant
A column of multipliers does not create four output columns.
Cross a column with a horizontal array
Read-only
Step-by-step guide · read-only ·
Loading your interactive spreadsheet…
Preparing the worksheet and formulas…
Data & tools
Task requirements
Enter one formula in G5. Return a three-row, four-column matrix. Each row uses its corresponding base amount from B2:B4; columns multiply that amount by 1, 2, 4 and 8. Apply the reduction in F2 to every result. Keep zero and signed amounts. B2:B4 are finite numbers within ±1,000,000; F2 is a numeric fraction from zero through one. Preserve all twelve positions even when every result is zero.
Change an actual source value
Choose a cell and its stored type, apply the value, then check the complete report again. A text key can contain literal punctuation. Ready values are actual Booleans. Invalid source types leave the worksheet unchanged.
This draft matches the current cell.
Follow the highlighted cells. Switch to Your turn to edit. Answer cells: G5:J7. Enter one formula in G5; keep the rest of the output area clear. Browser calculations may differ from your Excel version.
Selection & formula search
Practice stays on this device. No worksheet data is uploaded.
Notes & examples
About this lesson
Use one formula to expand three source amounts across four multipliers while keeping row and column meaning.
THE QUICK ANSWER01
Use one formula to expand three source amounts across four multipliers while keeping row and column meaning.
ƒx
=LET(amounts,B2:B4,factors,{1,2,4,8},amounts*factors*(1-$F$2))| One unit | Two units | Four units | Eight units |
|---|---|---|---|
| 9 | 18 | 36 | 72 |
| 0 | 0 | 0 | 0 |
| -2.25 | -4.5 | -9 | -18 |
The remaining reserved output cells are blank. Keep that area clear when trying the formula.
The formula uses the interactive worksheet above. Adjust ranges and criteria for your own data.
How it works
Read the directions
A vertical three-cell range supplies row identity. A horizontal four-value constant supplies column identity. Their element-wise product produces every row/column combination.
Try the first source
The reduction is 25%. The first row is 9, 18, 36, 72; the second row contains four measured zeroes; the third is -2.25, -4.5, -9, -18.
Enter normally
Enter the formula at one anchor. This lab uses dynamic spills and does not require Ctrl+Shift+Enter. Clear G5:J7 before trying another formula. Regional Excel separators and native edit/save remain separate from this English browser lab.
Read the full step-by-step walkthrough
- Recognize the vertical input
B2:B4 contains three rows and one column. Each output row must continue to use its corresponding original line.
- Build a horizontal constant
In this English formula syntax, commas separate columns. The constant {1,2,4,8} has one row and four columns; {1;2;4;8} would be vertical.
- Cross the two directions
Multiplication expands the three-row column against the four-column row. The output has three rows and four columns; it is not twelve unrelated formulas.
- Apply one scalar reduction
F2 is one number applied to every position. A full reduction returns twelve numeric zeroes without shrinking the spill.
- Inspect and recover the spill
Only G5 holds the formula. Inspect any named call or operator in the formula tools; clear an occupied output cell before applying a blocked spill again.
Things to watch
Returning a total
SUM collapses positions. This report needs a full three-by-four matrix.
Removing zero results
A numeric zero is a result at a specific position.
About this example
Original bounded arrays, complete typed outputs and current/changed-source browser calculations; native recalculation and edit/save remain separate.
Content version 1. Practice checks compare calculated results across different datasets; they do not certify every possible formula.