Pro-active formulae: setting another cell

  • Thread starter Thread starter chojan
  • Start date Start date
C

chojan

All of the excel formula commands I see are based on data from OTHER
cells, a sort of "reactive" cell. I need to be able to find some way to
SET another cell depending on the result of a conditional.

I think this goes against the paradigm for the way Excel spreadsheets
are supposed to work, but it would seem to be a fairly simple thing to
do, given a few rules (such as forced destination cell overwrites,
etc.) The power that this command would add to Excel could be fairly
significant.

For example, I would like to simulate a state-machine in Excel, with
the time axis represented by increasing rows.

I would like to have cell B10 have a formula like:
=IF(A10="GO",SET(C10,"DATA"),"")

The idea is that the cell is merely a placeholder for a "recalculate"
operation which will execute the data change in another cell, depending
on a condition.

A simpler case would be (for cell B10):
=SET(C10,A10+5)

Instead of setting cell C10 to:
=A10+5

Can this be done?
Thanks,
Cal.
 
Just to clarify the reasoning...

I would like to perform some sort of "arbitration" simulation, and
multiple cells might be able to reserve a "timeslot", so it is not
really appropriate to have the timeslot cells contain formulae.

Hope that makes some sense.
Cal.
 
Back
Top