E
Evelyn
I have a group of data that needs to calculate based on prior lin
result:
Example:
-----------
A B C D E F G
-----------------------------------------------------
1 Description Cost Jun Jul Aug Sep Oct
2 Asset 1 100 50 40 20
3 Asset 1 90 30 20 45
4 Asset 1 90 20
The sum of C2+D3+E4 must equal to the Cost. If this is not the case
the last entry (E2) will automatically adjust to the correct figur
(ie. 10 instead of 20). When this happen, the next line will start wha
E2 left off.
Figures in C to G column are calculated fields.
Is there any way that this can be achieved?
Thank you in advance for any help
result:
Example:
-----------
A B C D E F G
-----------------------------------------------------
1 Description Cost Jun Jul Aug Sep Oct
2 Asset 1 100 50 40 20
3 Asset 1 90 30 20 45
4 Asset 1 90 20
The sum of C2+D3+E4 must equal to the Cost. If this is not the case
the last entry (E2) will automatically adjust to the correct figur
(ie. 10 instead of 20). When this happen, the next line will start wha
E2 left off.
Figures in C to G column are calculated fields.
Is there any way that this can be achieved?
Thank you in advance for any help