IF statement within a IF statement

  • Thread starter Thread starter Eric
  • Start date Start date
E

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?
 
Eric said:
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?
Click to expand...

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)
 
Back
Top