Towery88Copper ContributorJun 11, 2020Interchanging Formula 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 ...Show More
bhushan_zIron ContributorJun 12, 2020Towery88 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.
