"Teri" wrote:
Thanks! The formula for the first statement worked perfectly, but I have NO
idea how to formulate the others........

As Pete hinted in his response, think you've got too many conditions to be
satisfied in your posts' portions 2 & 3. Review your requirements, then post
afresh. Keep it to one question per post (eg: if you have 2 questions, then
put in as 2 separate posts).
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---