thanks all for the help.. I edited the formula to:
=CHOOSE(SUM(IF(AND(D14+0=0,E14+0=0,ABS(F14+0)>1000),1),IF(AND(D14+0=0,E14+0=0,F14+0>-1000,F14+0<1000),2),IF(AND(D14+0<>0,E14+0<>0,D14+0=E14+0),3),IF(D14+0<>E14+0,4)),"W","X","Y","Z")
I am having one problem though. It will not let me record the macro.. When I write the code in a cell and press Enter, it gives me error> "Unable to Record"
I want to put a macro for one cell then double click the cell so it auto populates the rows below..
Is Choose function not allowed in macros?
Bookmarks