Flexible formula - cost, margin, sell price

[broadways]

I've search a lot on the internet about what I'm trying to achieve but could get an answer. So here it is:A simple calculationCost + margin = Selling price (ie, A1 + B2 = C3) - 100+200=300This is what I want to achieve:I want to able to put two values in any cell and get the answer in the missing cell.So if i enter: A1=100, C3=300, Answer in B2 should be 200Or if i enter: B2=200, C3=300, Answer in A1 should be 100Again, if i enter A1=100, B2=200, Answer in A3 should be 300Hope you understood my issue

 

[broadways]

I've search a lot on the internet about what I'm trying to achieve but could get an answer. So here it is:


A simple calculation
Cost + margin = Selling price (ie, A1 + B2 = C3) - 100+200=300


This is what I want to achieve:
I want to able to put two values in any cell and get the answer in the missing cell.


So if i enter: A1=100, C3=300, Answer in B2 should be 200
Or if i enter: B2=200, C3=300, Answer in A1 should be 100
Again, if i enter A1=100, B2=200, Answer in A3 should be 300


Hope you understood my issue