T
Tony
Can you do a calculation on a cell, get the answer and then post it back to
the same cell?
the same cell?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
L
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)
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)
L
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.
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.