I need to do some validation on an Excel file that I have. Rather than type the longest "IF" formula known to man into the formula bar, I'd like to create my statements in the VB Code window.

That way I can basically use VB syntax and make things easier to read.

So if I want an IF statement in Cell C6 how would I go about doing so?