DRSteele
Well-known Member
- Joined
- Mar 31, 2015
- Messages
- 2,667
- Office Version
- 365
- Platform
- Windows
Can someone please help me?
I am trying to create an array formula that iterates on the prior result. Here, the formula I have copied downwards uses the prior row's result. Instead I want an array formula that spills the results from one cell.
And I would also really like the array to stop before it first hits zero (i.e., upon the first time it goes to a fraction, 0.3055 here).
I am trying to create an array formula that iterates on the prior result. Here, the formula I have copied downwards uses the prior row's result. Instead I want an array formula that spills the results from one cell.
And I would also really like the array to stop before it first hits zero (i.e., upon the first time it goes to a fraction, 0.3055 here).
| number bases.xlsx | |||
|---|---|---|---|
| D | |||
| 3 | 36 | ||
| 4 | |||
| 5 | 19345992 | ||
| 6 | 537388.667 | ||
| 7 | 14927.4444 | ||
| 8 | 414.638889 | ||
| 9 | 11.5 | ||
| 10 | 0.30555556 | ||
| 11 | 0 | ||
| 12 | 0 | ||
| 13 | 0 | ||
| 14 | 0 | ||
Sheet1 | |||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| D6:D14 | D6 | =TRUNC(D5)/$D$3 |
