mclifford63
New Member
- Joined
- Apr 12, 2020
- Messages
- 2
- Office Version
- 2019
- Platform
- Windows
I am trying to do the following WITHOUT VBA. I have most of this working using MOD/column formulas, but cannot get it to include both the growth of cells and fixed values at the same time:
X = 10
N = 5
F = 0
FS = 2
FN = 2
G = 100%
Output: 0, 0, 10, 10, 10, 10, 10, 0, 0, 20, 20, 20, 20, 20, 0, 0, 40, 40, 40, 40, 40, 0, 0, 80, 80, 80, 80, 80
Example 2:
X = 10
N = 3
F = 0
FS = 0
FN = 1
G = 100%
Output: 10, 10, 10, 0, 20, 20, 20, 0, 40, 40, 40, 0, 80, 80, 80
Example 3:
X = 10
N = 2
F = “Blue”
FS = 3
FN = 1
G = 100%
Output: Blue, Blue, Blue, 10, 10, Blue, 20, 20, Blue, 40, 40, Blue, 80, 80, Blue
- Starting Value (call it X)
- N (repeat same value this # of times)
- Fixed Value to appear after N columns (call it variable F)
- # of Times Fixed Value to appear BEFORE "Starting Value" starts to appear (call this FS, in the beginning needs to be offset with the fixed value)
- # of Times Fixed Value Appears (call it variable FN)
- Value Growth (after same value repeats N times and the fixed value(s) appear, the next value will be the previous value increased by this %; call this variable G)
X = 10
N = 5
F = 0
FS = 2
FN = 2
G = 100%
Output: 0, 0, 10, 10, 10, 10, 10, 0, 0, 20, 20, 20, 20, 20, 0, 0, 40, 40, 40, 40, 40, 0, 0, 80, 80, 80, 80, 80
Example 2:
X = 10
N = 3
F = 0
FS = 0
FN = 1
G = 100%
Output: 10, 10, 10, 0, 20, 20, 20, 0, 40, 40, 40, 0, 80, 80, 80
Example 3:
X = 10
N = 2
F = “Blue”
FS = 3
FN = 1
G = 100%
Output: Blue, Blue, Blue, 10, 10, Blue, 20, 20, Blue, 40, 40, Blue, 80, 80, Blue