Excell calculations

Closed
Report
-
Posts
1219
Registration date
Wednesday July 28, 2004
Status
Contributor
Last seen
November 25, 2013
-
Hello,
I am a programmer and not use to restrictions when calculating formulas. I would like to know if there is a way to calculate a number and place the result back in the same cell. EX (A1+B1=A1) the formula would be in A1.

1 reply

Posts
1219
Registration date
Wednesday July 28, 2004
Status
Contributor
Last seen
November 25, 2013
28
Hello,
yes this can be done, it would be some kind of an iterative calculation...therefore you need to allow iterations and set the max number of iteration....(options/formulas/calculate mode or something like that, i use excel in french so i'm not sure about the translation of menus...)..Then simply type =A1+B1 in cell A1...