On Thursday, May 10, 2012 5:21:55 PM UTC-5, Maury Markowitz wrote:
What I'm thinking might be impossible, but here goes.

I have three columns that are initially filled with data from a DB,
and then I copy those values into formulas that produce the same
output. The reason is that each of two columns are dependant on the
other and could be overridden by the user...

cost = a number from the db, or typed in by the user
markup = a number from the db, or typed in, or calculated as (price-
cost)/cost, from...
price = cost*markup, or typed in

So basically what I'd like is for the user to be able to type into any
of these three fields, and have the others update.

So if they type into markup, the price should change, and if they
change the price, the markup should change.

I'm sure this comes up a lot, but my Google-fu is failing me, I can't
figure out what to search on.

Shoudn't be a problem. send file to