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!