Suggestion - turn on the macro recorder (Tools->Macro->Record New Macro) and type in the formula you want in the cell. Stop the recorder and see what you get. Maybe you already did this.......

VBAhack