DynV
New member
- Joined
- Dec 22, 2017
- Messages
- 20
I have a mostly automated profile/sheet/information that I'd like to automate even more as it allow custom formulas using limited data and operations. In the following table the column (col) 1 is entered and col 2 is automated and I'd like to do so for col 3 (reason in previous sentence). In the custom formulas the only information related to col 3 is col 1 & 2 and operations are arithmetic (only +, -, x, /) and rounding: round(), floor(), ceil(). There is no need to figure col 2, it's only there if it helps finding the restricted formula for col 3; although if there's a way to only get it from col 1, it would be a bit more robust.
I'm not sure if this is the right forum for this request, moderators please change it if appropriate, or those that know one to send them a suggestion to do so.
Thank you kindly for your help
Update 1: Added rounding operations.
Update 2: In the sentence starting with "There is no need to figure col 2", the semi-column and its rest.
1 | 2 | 0 |
2 | 2 | 0 |
3 | 2 | 0 |
4 | 2 | 0 |
5 | 3 | 0 |
6 | 3 | 0 |
7 | 3 | 0 |
8 | 3 | 0 |
9 | 4 | 1 |
10 | 4 | 1 |
11 | 4 | 1 |
12 | 4 | 1 |
13 | 5 | 2 |
14 | 5 | 2 |
15 | 5 | 2 |
16 | 5 | 2 |
17 | 6 | 3 |
18 | 6 | 3 |
19 | 6 | 3 |
20 | 6 | 3 |
I'm not sure if this is the right forum for this request, moderators please change it if appropriate, or those that know one to send them a suggestion to do so.
Thank you kindly for your help
Update 1: Added rounding operations.
Update 2: In the sentence starting with "There is no need to figure col 2", the semi-column and its rest.
Last edited: