Thread: Bi-Lateral Formula

Is there a way to create a formula that would allow you to enter data into one cell and it would populate another and vice versa? I realize this creates a circular reference normally, but I was hoping someone might have an elegant solution for this.

What I am trying to accomplish is this:
On our project fee breakdown schedule, some users would like the ability to enter a person's hours and have it populate a percentage field. Others would like to use the percentage field and have it populate the hours. I would like to accommodate both requests, but am not sure how.

Any suggestions would be most appreciated.

If you want the users to input into either/or then you would need to use VBA to conduct the calculations.

A cell in XL contains either a manual input or a formula - never both.

If VBA is not viable then you will need to have 2 separate cells for inputs (hours / %) and 2 cells for calculated values (hours / %) - the calculations designed to work off whichever of the inputs has been populated.