|This sounds like a homework problem. Have you tried anything on your own?|
BTW...what do you mean by "end"?
In any case, perhaps this explanation will get you started...
An IF statement has this syntax:
=IF(logical_test, value_if_true, value_if_false)
A Nested IF is an IF statement where the value_if_false is another IF statement:
=IF(logical_test, value_if_true, IF(logical_test, value_if_true, value_if_false), etc.)
An AND statement compares multiple arguments and returns TRUE only when all arguments are TRUE.
Try an AND statement as your logical_test and see what happens.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.