project 15 this project involves an embedded if statment you can do it in other ways when you have three states but most if statements have if then so if its true its one thing, if its false its another thing and so I always use the little if box so first thing we need to do to set this up is let me note I made this all larger, there are two tabs down here, two sheets order sheet and the discount sheet and they are already set up for you and the discount is if its less than $500 you don't get a discount, if the paint you buy is between $500 and less than 1,000 you get a %5 discount if you spend over $1,000 dollars you get a %10 discount so there's three states here and most if statements just do 2 states if true false and so we have to have an embedded if statement embedded meaning it is in the last part of the box and I will show you but before we do that lets extend the price here that would be equals this times that the quanity fill down 