IF statements are useful in the decision-making process; however they can also become confusing and complicated. Nesting IF statements allows you to ask a question. If the answer is true or yes, you can ask another question. If it is false or now, you would ask a different 2nd question. Each subsequent question depends on the outcome of the last question.

For this assignment, you will create a decision tree and build a nested if statement for the following scenario: You are setting up a raise percentage for your bakers based on experience using the W3 Baker spreadsheet.

Employee	Hourly Wage	Years of Experience	New Hourly Wage
Grace	11.00	0
Katherine	12.00	5
Marvin	17.50	9
Gene	13.75	2
Sandra	23.50	15

Timeline

Years of Employment	Raise %
0-4	2
5-9	3
10-13	4
14-17	5

Create a decision tree diagram using the information above. (See Figure 4.32 in the text.)

You may use the cells below, SmartArt, or the draw tools to create your diagram on the Excel Worksheet.

Then create a nested IF statement to compute the new hourly wage for your employees.

Insert the formula into the "New Hourly Wage" column and format as Currency with 2 decimal points.