Replace function with conditions

[manharji]

Please see attached file.
I have data in A,B,C, and D column.

Based on following conditions i would like to fill column E with X, Y or Z

IF (C1>-2 AND <2) AND (D1="") THAN E1 DISPLAY "Z"
IF (D1= 0) AND (C1="") THAN E1 DISPLAY "Z"
IF (A1>5) THAN E1 DISPLAY "Z"


IF (D1< 0) AND (C1="") THAN E1 DISPLAY "X"
IF (C1<-1) AND (D1="") THAN E1 DISPLAY "X"

IF (D1> 0) AND (C1="") THAN E1 DISPLAY "Y"
IF (C1>2) AND (D1="") THAN E1 DISPLAY "Y"

Thanks for help

[Sam Capricci]

I think this will work for you in cell E1 =IF(AND(C1>-2,C1<2,D1=""),"Z",IF(AND(D1=0,C1=""),"Z",IF(A1>5,"Z",IF(AND(D1<0,C1=""),"X",IF(AND(C1<-1,D1=""),"X",IF(AND(D1>0,C1=""),"Y",IF(AND(C1>2,D1=""),"Y",""))))))) however, your profile says you have 2003 and that may not handle this many if then statements.

EDIT: I think it will handle that many IF stmts, I think the # is 7 or 8 for .

[samanyu]

Hi manharji,

Your result doesn't seem to be using the column B anywhere. Did you overlook it?

The current problem can be solved by pasting the following formula in cell E1 and copying it down till required.

Please Login or Register  to view this content.

-Samanyu

~Taking over the world, one cell at a time!