Clearing cell contents from within a function

Thank you in advance for any assistance that may be offered! I rarely use macros and have never played with Visual Basic, so please be patient with my ignorance!

Has anybody ever cleared the contents of a small range of cells from within another function such as an "IF" statement? I thought this would be easy, but in fact, has turned out otherwise. To my dismay, I found out you can't run a macro from within a function either (which would have made the problem trivial!). Using a "conditional format" to hide the cell contents is not really an option as I need to eliminate the text so other calculations are not performed.

Any assistance would be greatly appreciated!

Just wanted to update my previous question---thanks to a couple other folks who suggested the following solution:

Since I was unable to have the macro run directly from within an IF..THEN statement in the worksheet, it was suggested to use a checkbox control, then insert the clear-cells command within that sturucture. Worked great. Thanks to all again!