Hello everyone,
I am struggling with this table to make it work as i want and i have no success until now, maybe you can give me a hint.
This should work like this:
In column G will me different values
In column I are the values that I have to retain
In Column H I should have what remain for each one.
The idea is that I want the sum of what i need to retain to be subtracted in the same order as appears in column G. First two subtractions are work, from the third one...can't figure it out.
Thank you all in advance!
I am struggling with this table to make it work as i want and i have no success until now, maybe you can give me a hint.
This should work like this:
In column G will me different values
In column I are the values that I have to retain
In Column H I should have what remain for each one.
The idea is that I want the sum of what i need to retain to be subtracted in the same order as appears in column G. First two subtractions are work, from the third one...can't figure it out.
Thank you all in advance!
Alesi A. - Ciltea S..xlsx | |||||||
---|---|---|---|---|---|---|---|
G | H | I | J | K | |||
41 | Inainte de retinere | Dupa retinere | Retineri | Total de retinut | Rest de retinut luna viitoare | ||
42 | Bonus Reclamatii | Bonus Reclamatii | Echipament | 150,0 € | 20,00 | ||
43 | 50,0 € | -100 | 150,0 € | ||||
44 | Bonus Vechime | Bonus Vechime | Km privati | ||||
45 | 100,0 € | 0 | |||||
46 | Bonus Diverse | Bonus Diverse | Naveta | ||||
47 | 20,0 € | 0 | |||||
48 | Diurna | Diurna | Accident | ||||
49 | 0 | 20,0 € | |||||
50 | |||||||
51 | La contabila: | ||||||
52 | Bonus Reclamatii | 0 | 0 | ||||
53 | Bonus Vechime | 0 | 0 | ||||
54 | Bonus Diverse | 0 | 0 | ||||
55 | Diurna | 20 | 0 | ||||
Alesi Angela |
Cell Formulas | ||
---|---|---|
Range | Formula | |
J42 | J42 | =SUM(I43,I45,I47,I49) |
K42 | K42 | =SUM(G43,G45,G47,G49)-J42 |
G43 | G43 | =E39 |
H43 | H43 | =G43-J42 |
G45 | G45 | =R4 |
H45 | H45 | =G45-(J42-G43) |
G47 | G47 | =SUM(F39,H39,S4,T4) |
H47 | H47 | =(G45+G43)-(J42-H45) |
G49 | G49 | =SUM(L76:L102) |
H49 | H49 | =G49+G47+G45+G43-J42-(H52+H53+H54) |
H52 | H52 | =MAX(H43-I52,0) |
H53 | H53 | =MAX(H45-I53,0) |
H54 | H54 | =MAX(H47-I54,0) |
H55 | H55 | =MAX(H49-I55,0) |