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.

--
Regards,
Tom Ogilvy

"rmc5446" wrote in message
...

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 answer
"50" to A1 the defined cell. This would allow one to leave A1 free of
formulas and the ability to manually input data into the cell without
writing over and deleting an IF statement (usually found inside the
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

Rob


--
rmc5446
------------------------------------------------------------------------
rmc5446's Profile:
http://www.excelforum.com/member.php...o&userid=16009
View this thread: http://www.excelforum.com/showthread...hreadid=274753