Hello friends,

Gross 2000000
18% 360000 (18% never changes)
2% 40000 (this is a dynamic value and keeps changing to 8%, 10% etc.)
Net 2320000

This is what I have in range A1:B4
Formula in B2 : =B1*A2
Formula in B3 : =B1*A3
Formula in B4 : =SUM(B1:B2)-B3

I am unable to calculate it reverse. Lets say I have only two values available, Net ( 2320000) and 2% then how can I calculate the Gross (2000000)?

Please help.