First of all, for any cell to have an automatic value assigned to it must be initated by a button push. With thta being said, the syntax for IF is as follows:
And the syntax for AND is as follows:
=AND(first_test_for_true,Second_test_for_True) [returns true if both are true.
So, with the above syntax, we can combine, starting with an AND. As in:
And there you have it. Play with it and see what happens. I will check back if you have any questions.
Please understand I will not rewrite my examples to fit your model. The examples are there for you to learn by, not cut and paste into your homework!!!!!!