We have a worksheet with two columns that contain formulas that are dependent on each other because this is how orders are placed.
If a customer orders cartons of an item, then we enter the carton quantity in column F and it calculates eaches in column G, but often a customer orders eaches we enter the eaches quantity in column G which calculates the quantity of cartons in column F. An order very often will contain a combination of cartons and eaches. This adds up cartons, eaches, and numerous other things to create an estimate of weights and measures for shipping purposes. (See attached example).
(Yes...I know this creates a circular reference but I've already allowed for iterations)
The problem is that the user often puts a quantity in the wrong column thus wiping out the formula. Is there a way to delete/change a quantity without affecting the formula?
Thanks in advance!!!
Bookmarks