How do I run a macro from inside an"=IF" formula in Excel 2003?

[Guest]

I need to run a short macro from inside an Excel "IF" formula; running one
macro when the "IF" statement is TRUE, and another macro when the "IF"
statement is FALSE.

 

[moon]

I need to run a short macro from inside an Excel "IF" formula; running one
macro when the "IF" statement is TRUE, and another macro when the "IF"
statement is FALSE.

You can do that, but not from a 'normal' IF-formula. First create your own
user defined function, like =OWNIF(), and then call a macro from there.