IF statement within a IF statement

[Eric]

I have a worksheet with data like:

A1 = 2
B1 = 0EPS
C1= 1-May-03
D1= 1
E1= 2

What I am trying to accomplish is IF B1 = 0EPS AND C1 is
less than 7/1/03 Then (If True) D1, (If False) 0

I had my formula set like:
=IF(B2="0EPS",IF(C2<7/1/3,D2,0),0)

What am I doing wrong?

 

[Anon]

I have a worksheet with data like:

A1 = 2
B1 = 0EPS
C1= 1-May-03
D1= 1
E1= 2

What I am trying to accomplish is IF B1 = 0EPS AND C1 is
less than 7/1/03 Then (If True) D1, (If False) 0

I had my formula set like:
=IF(B2="0EPS",IF(C2<7/1/3,D2,0),0)

What am I doing wrong?

Nothing to do with 'IF within IF'. It's just that 7/1/3 isn't a date - you
have to make it into one:
=IF(B2="0EPS",IF(C2<DATEVALUE("7/1/3"),D2,0),0)