Oh yea! B2 should be B1, sorry. One possible solution I found out may be by
using a VB macro here is what I came up with:

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Address = "$B$1" And IsNumeric(Target) Then
Range("A1") = Range("B1") / 7
End If

If Target.Address = "$A$1" And IsNumeric(Target) Then
Range("B1") = Range("A1") * 7
End If
End Sub
I'm very new at this and understand very little about VB, just learning some
things from the people in this forum, so the formula may not be correct.
John what do you think about this? Is this look Ok to you.

Kevin Brenner


"John Tjia" wrote in message
om...
I assume the B2 in the first line should have been B1.

It doesn't seem possible for the solution as you envision, since
entering a number into A1 would delete the formula there, and likewise
for the cell B1.

"Kevin" ! wrote in message
...
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