I have 2 cells: Cell A is for mg/L and Cell B is for lbs.
I would like to enter a value in either Cell A or Cell B (not both) and have a calculated result display in the other cell.
If I enter data in Cell A (mg/L), I would like to have the calculated value of lbs display in Cell B.
If I enter data in Cell B (lbs), I would like to have the calculated value if mg/L display in Cell A.
The calculation for Cell B is Cell A * MGD (from another cell) * 8.34.
The calculation for Cell A is Cell B / (MGD * 8.34).
Is this possible? How would I go about doing this?
Thank you.
I would like to enter a value in either Cell A or Cell B (not both) and have a calculated result display in the other cell.
If I enter data in Cell A (mg/L), I would like to have the calculated value of lbs display in Cell B.
If I enter data in Cell B (lbs), I would like to have the calculated value if mg/L display in Cell A.
The calculation for Cell B is Cell A * MGD (from another cell) * 8.34.
The calculation for Cell A is Cell B / (MGD * 8.34).
Is this possible? How would I go about doing this?
Thank you.