Forum Discussion

Towery88's avatar
Towery88
Copper Contributor
Jun 11, 2020

Interchanging 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 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.




excel
Formulas and Functions

2 Replies

  • bhushan_z's avatar
    bhushan_z
    Iron Contributor
    Jun 12, 2020

    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.

  • SupreethGuptha's avatar
    SupreethGuptha
    Copper Contributor
    Jun 11, 2020
    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

Resources