Forum Discussion
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 ...
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
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