Excel 2007 : If(and(or

[Excelcakes]

I have three columns, A, B, and C. What I am trying to do is to make column C represent the "statuses" of columns A and B (per row of course). There are three possible outcomes in columns A and B. They can both be blank, one or the other can have a date (but never both columns with a date at the same time), or one of the columns will have the word "rejected" (again, never will both of the columns have "rejected" at the same time).

This is what I need in column C;

If both columns A and B are blank then column C needs to say "No Feedback"
If either column A or B have a date then column C needs to say "Approved"
If either column A or B have the word "rejected" then column C needs to say "Rejected"

I have tried a few of my own if(and(or combinations but am getting confused becasue of all of the possible outcomes and lengthy formulas. Any help would be appreciated. Thanks.

[Andrew-R]

Working with row 1:

=IF(AND(A1="",B1=""),"No Feedback",IF(OR(A1="Rejected",B1="Rejected"),"Rejected","Approved"))

This assumes that A1 & B1 will always be blank, or be "Rejected" or contain a date. Other values will cause the formula to spit out "Approved", even if the values in there aren't dates.

[JieJenn]

I cannot guarantee the date check will work 100% accurately, but the rest should be good.

=IF(AND(ISBLANK(A1),ISBLANK(B1)),"No Feedbacks",IF(OR(ISNUMBER(A1),ISNUMBER(B1)),"Approved",IF(OR(PROPER(A1)="Rejected",PROPER(B1)="Rejected"),"Rejected","")))

[Excelcakes]

Thank you Andrew-R, works perfect.