Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
IFPUSH & IFRUN functions??? Please help
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 -- rmc544 ----------------------------------------------------------------------- rmc5446's Profile: http://www.excelforum.com/member.php...fo&userid=1600 View this thread: http://www.excelforum.com/showthread.php?threadid=27475 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
IFPUSH & IFRUN functions??? Please help
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to convert cell formula functions to code functions | Excel Discussion (Misc queries) | |||
efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
Looking for a site with functions that substitute the ATP functions | Excel Worksheet Functions | |||
Nesting functions in the functions dialog box | Excel Worksheet Functions | |||
excel functions and User defined functions | Excel Programming |