View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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?