I'm sure there is a simple fix to this problem but I am at a loss.
I have 3 numbers a quantity, total cost and item cost. I need to see each of them in a column each on its own row. I always know the quantity but sometimes I know the total cost or the item cost. I want to be able to put in one of these costs and have the other cost calculated. For example Q=2000,/TC=$4000 there for IC=$2 But if I only have the item cost then I want to find the total cost so Q=2000*IC=$2 therefore TC=$4000.
And I need to be able to change one of these numbers at any time and have it automatically change the other. I then use these numbers for different calculations. Any thoughts?
I have 3 numbers a quantity, total cost and item cost. I need to see each of them in a column each on its own row. I always know the quantity but sometimes I know the total cost or the item cost. I want to be able to put in one of these costs and have the other cost calculated. For example Q=2000,/TC=$4000 there for IC=$2 But if I only have the item cost then I want to find the total cost so Q=2000*IC=$2 therefore TC=$4000.
And I need to be able to change one of these numbers at any time and have it automatically change the other. I then use these numbers for different calculations. Any thoughts?