Cell A1 has a formula B1*7 and cell B2 has formula A1/7. So I have created
a circular reference! now, is there a way around this problem. What I like
to do is when a value is written on A1 the calculation appears in B1, but
when a value is added to B1 it would change A1. I'm more interested to see
if there is a solution to this type of problem more than the answer it
self.. I figure that many other calculations can be executed bases on this
idea.

Thank you