Problem:

Cell A1 is data entry =quantity on hand
Cell B1 is data entry = quantity sold
Cell C1 is data entry = quantity received
Cell D1 is formula = new quantity on hand (A1-B1+C1)

What I want to do is have only one 'quantity on hand' column.

A1 = A1-B1+C1 which is a circular reference, and no matter what sort of
formula I use, IF, AND, etc., it continues to be circular as long as the
value in A1 is part of the formula.

No doubt the answer is perfectly simple, and I'm just not asking Help the
right question. After all, every inventory program must need that basic
function.