Combining Conditions within conditional formula

[NickHubble]

Hi there, i wonder if you can help. Very briefly i am trying to achieve old products on a database that we no longer have any stock of and we haven't sold since a specific date. I am having probems with an "=if(and" formula. At least i thin it is an equals if and formula that i need. Basically i need to say the following:

=if(Stock quantity column = 0 and the date field is <= 31/12/2005 then "Delete" or "Keep")

Please help!

Many Thanks

Nick

[NBVC]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[NBVC]

Really not a better title.... try something like "Combining Conditions within conditional formula" or similar

then try this formula

=if(And(A1=0,B1<="31/12/2005"+0),"Delete","Keep")

where A1 and B1 are the cells checked for the conditions

[NickHubble]

Thank you very much it works perfectly, i almost had it right, just didn't have the +0 after the date.

Thanks

Nick

Ps will try harder next time with a decent title.

thanks again