conditional formulae
First...........a formula cannot increase another cell value, it can only
return values to the cell in which it is written.
You could write in C1 =IF(B1<A1,B1 + 16)
You may need sheet event code.................post a few more details on
what you would like to achieve.
i.e. which cells or values and what would "some value" be equal to
Gord Dibben MS Excel MVP
On Sun, 14 Sep 2008 21:24:01 -0700, fredtheengineer
wrote:
I would like to create a conditional formula that would initiate an iterative
process such that: If X < Y, then increase a cell value by some value, then
recalculate the spreadsheet. Can this be done?
|