How do you update a cell after an operation on it.

[Tony]

Can you do a calculation on a cell, get the answer and then post it back to
the same cell?

 

[Luke M]

Not without using VB.

Sub CircularLogic()
Range("A1") = Range("A1").Value + Range("C1").value
end sub

You can then either assign the macro to a hotkey, a command button, or an
event (in VB)

 

[Luke M]

My apologies. I forgot to mention that you *can* do it with just formulas, if
you turn off automatic calculation. (tools-Options-calculation, set to
manual, iterations to 1).

Now you could put in A1
=A1-C3
and everytime you press F9, XL would perform a calculation.