Jun 11 2020 07:32 AM
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.
Jun 11 2020 10:40 PM
Jun 12 2020 01:11 AM
@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.