Excell calculations

Closed
ken - Jan 14, 2010 at 11:50 AM
tompols
Posts
1219
Registration date
Wednesday July 28, 2004
Status
Contributor
Last seen
November 25, 2013
- Jan 14, 2010 at 12:07 PM
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

tompols
Posts
1219
Registration date
Wednesday July 28, 2004
Status
Contributor
Last seen
November 25, 2013
28
Jan 14, 2010 at 12:07 PM
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...
0