You could use a circular formula with calculation set to iteration, but that has very limited context. You could use VBA's Worksheet Change event, but that's cumbersome at best. I recommend that you create a data entry user form and let the form do the calculating. Your users might find data entry a lot easier using a form.