Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Microsoft Excel Question?
I want to create a formula which would do a calculation based on which cell the value is entered into.
What I mean is the use enters a value in G16, then the formula in I16 would be G18-G16. But if the user enters the value in I16, the formula in G16 would be G18-I16.
When I try to enter the formulas as if(G16, G18-I16,"") and if(I16,G18-I16,""), I get a circular reference error - which I understand. But as soon as the user enters a value in G16 or I16, the error would go away.
1 Answer
- supastremphLv 65 years ago
If I read this correctly, if a user enters a value in g16, then it destroys a previous formula written in g16? This is pretty poor form. What you want is a calculation cell that looks at the two input cells to determine what to insert. For the sake of argument, let's put your input somewhere else, call them i16' and G16'. Let I16=G18-G16' and G16 = G18 - I16' If you need one or the other to be zero when the other is nonzero, simply multiply by an if statement. Would this work?
