IFPUSH & IFRUN functions??? Please help

[rmc5446]

I am trying to create an IFPUSH fuction and am having a difficult time.
The statement would allow one to say:

IFPUSH(A10="yes", A1=50, "")

This function could be embedded in any cell and would "push" the answe
"50" to A1 the defined cell. This would allow one to leave A1 free o
formulas and the ability to manually input data into the cell withou
writing over and deleting an IF statement (usually found inside th
designated) that affects them.

Another way to do this is to embed a macro inside of an if statement:

IFRUN(A10=YES, 'run macro yes',"")

is this possible? Please email me if these are not a clear questions

thanks

Ro

 

[Tom Ogilvy]

It isn't possible. Cells can't alter other cells, but can only return a
value to the cell in which they are located. Your macro idea (IFRUN) won't
fly either.