Hi,

I need to make a reverse calculation based on a few formulas like below.

I have this datas starting with A1:

A B C D E F G
1 gross som cas cass deduct imp net
2 2200 11 231 121 320 243 1594

Formulas:

B2 = A2*0.5%
C2 = A2*10.5%
D2 = A2*5.5%
E = 320 (fixed value for all)
F = (A2-B2-C2-D2-E2)*16%
G2 = A2-B2-C2-D2-F2


What i need is to put a value in G3 (ex: 2200) and to find the values in A3, B3, C3, D3, E3, F3.

Can this be done?

Thank you kindly,
Puiuluipui