Cross a column with a horizontal array
Your goal: Use one formula to expand three source amounts across four multipliers while keeping row and column meaning.
Full 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.
One vertical source crossed with four horizontal multipliersCalculate G5: line 1, 1 units
Shared reduction · F2: 0.25
| # | |||
|---|---|---|---|
| 1 | |||
| 2 | |||
| 3 | |||
| 4 |
Step 1 of 12
Calculate G5: line 1, 1 units
Rules for this step
Pair the base in this output row with the shared F2 reduction. The output column supplies the multiplier. Keep zero and signed results.
Calculation rule
base × multiplier × (1 − reduction)