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 |