How to enter this formula as VBA?

[glennchung]

I have the following formula and would like to include it in a macro. I managed to include the first formula in my macro using double double-quotes but I couldn't figure out a way to include the second formula which is simply an extended IF/THEN/ELSE statement.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thanks!!

GC

[davesexcel]

The Macro recorder works great for this.
Start the Macro recorder, select the cell that has the formula you want, select the formula bar and hit the Enter Key, Stop the Macro recorder, go to the VBA editor and check out the formula.