Conditional Formula that meet 2 criterias

[zicitron]

Hi all,

I an using Excel 2010. I have a worksheet where Column B has a list of dates in the following format (Jul-10,Aug-10,.......and so on). In Column C, I have a list of 3 names (eg: Alan, Smith, Jones). I need a formula in Column D that will fill the cells with a condition similar to this:

IF B1>= Jul-11 and C1= "Alan", THEN D1 = 60

IF B1>= Jul-11 and C1= "Smith", THEN D1 = 55

IF B1>= Jul-11 and C1= "Jones", THEN D1 = 40

Thanks for your help!

[ragulduy]

=If(and(B1>="Jul-11",C1="Alan"),60,if(and(B1>="Jul-11",C1="Smith"),55,if(and(B1>="Jul-11",C1="Jones"),40,"")))
or
=IF(B1>="Jul-11"",IF(C1="Alan",60,if(C1="Smith",55,if(C1="Jones",40,""))),"")

[SDCh]

If on column B format as date
try this

=IF(MONTH(B1)>=7,IF(C1="Alan",60,IF(C1="smith",55,40)),"")