Interchanging Formula

Highlighted
Occasional Visitor

I want a way to input data fast depending on what data I have available.

A1+100=B1 <---> B1-100=A1

So if I happen to have A1 it will auto calculate into B1 cell but,
If i have B1 I want it to autocalculate into A1 without erasing the formulas and remaining interchanging should I change the value in A1 it will change the value in B1 regardless of what the intial input is.




2 Replies
Highlighted
Hi

If only 1 value is available, (i.e. Either A or B), then you could try
=if(A1="",B1-100,A1+100)

Hope this works
If you need more help, send me an email

Regards
Supreeth
supreeth.guptha@gmail.com
7019131376
Highlighted

@Towery88 I think that is not possible.

You can not have 2 way formulas.

I mean, you can have, but it will lead to Circular Referencing and could lead to more errors.

Unless you are sure, how to use Circular Referencing and Iterations, avoid it.