In cell I5, enter an “AND” IF function that enters F5*.10 if the value in the Program range is
English AND the value in the Level range is 1. If neither of these criteria are met, enter a 0. The
purpose of this IF function is to offer a 10% discount to students who are taking Level 1 English.
You should see 0 in cell I5 and $200 in cell I7
Bookmarks