Project #1 Due:

Project #1                                                                                                                             Due: Sunday at 6pm

Nesting function project with conditional formatting

Definition: 

              Nesting functions allows for multiple calculations to take place in a single cell.

              Conditional Formatting selects one or more cells, and creates rules (conditions) for when and   how those cells are formatted. The conditions can be, based on the selected cell's contents, or     based on the contents of another cell.

This is a very tricky project but once mastered, you will be an expert on nesting functions. Please read the instructions carefully and use the referenced videos.

You will need to use an IF statement to determine the value of the letter grade.

An IF statement consists of a condition, a true value, and else value

For example:

                       In Cell D4  type:   =IF(