Hi
Simply NO! in open formaul as Mark W states YOU WILL gwt a little blue dot and a pop up box ir Circula Ref this means you calculation using the same cell twice ie D2 value multi by A2 value thisis fine but wnating the answer in D2 is pushing it, it will hate it, look at it as a kind of loop if this were poss would excel just continue to change the result, like VBA loop can do just looks all nice and pretty but WORTHLESS.
Can be done in VBA thou:
The reason is we can assign a value to memory and recall it so D2 we can name as Jack so A2 we can name as IN THE so noew Jack add IN THE is fine, but we can clear the cells in VBA so they are empty and say add Jacj to IN THE and we are fine to put that back in the same cell, cool eh!
Then can also be done only once so as i explaind no looping takse place and and will get the correct result.
I cant say i recomend this but feel should it be a MUST MUST then can be done,
This is very close to the way programmes add 1 to a sales documents to always be differene say on close A1+1 will do this.
Hope that kinda of explains it in a fashion, maybe some one might translate a bit better my command of english is none so good at times.