Excell calculations

Closed
ken - Jan 14, 2010 at 11:50 AM
tompols Posts 1273 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.
Related:

1 response

tompols Posts 1273 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