=IF(ISBLANK(B5),””,B5) -This code looks at cell B5 if it is empty it will leave the cell this formula is in blank but if B5 has something in it then it will return what is in B5. Also the 2nd B5 in this formula can be anything adding other cells, returning the value of another cell, a lookup function, or whatever you need it to be an example will up this will follow later down the page.

=VLOOKUP(J7, B4:C41, 2, FALSE) - This code here is a vertical lookup function. What is says/does is this it will look in cell J7 then it will look in the column B from B4 down to B41 if there is a match to J7 the it will return the value in the cell beside it from column C. For example say B22 has the same information as J7 then it would return to you what is in C22. The 2 in the formula refers to the column in the selected range B4:C41 but you can expand on this. For example you can say D2:Z54 and all you have to do is tell it what column you want so if you wanted what was in column K then you would put an 8. Remember this formula will be in a cell that is not involved with the formula. With this formula you will be putting your information you want to look up in J7 and the results will be displayed in the cell that you have this formula. In the beginning of this statement I told you this is a vertical lookup function well if you change the V to an H it will then become a horizontal lookup function. SO if this was a horizontal lookup function then the formula would look like this. =HLOOKUP(J7,B4:Z5,2,FALSE) this would search for J7 on row 4 and display what is on row 5.

=IF(ISBLANK(B8),"",IF((AND(H8>$B$1,K8>$B$1)),"NO","YES")) - Okay this formula is a little bit more advance what we have here is a combination of 2 formulas together. The first part of the formula is the same as the 1st formula I explained. As I also explained you can put whatever you want on the 2nd half of it and that is what we did here. What we added was another formula and what this 2nd half does will return YES or NO in the cell that you have it in. Now let me break down this 2nd formula to you. H8 is a cell that has information in it and it is being compared to B1 and K8 also has information in and it is being compared to B1. Now if H8 or K8 is greater than B1 it will return the word NO but if either one of them is less then B1 then it will return the word YES. Now I expect you have a question in regards to the $ on B1 I will explain this to you next.

B1, $B1, B$1, and $B$1 - These are all the same what the $ does is basically locks the follows character or number so it will not change if you choose to drag the formula across other cells. For example the B1 if you was to grab the bottom corn of the cell and drag it down B1 would change based on how many cells you went down. We will say you dragged it down 3 cells so it would change like this B1, B2, B3, B4. If you dragged it across it would change like this B1, C1, D1, E1. Now lets place $ in front of the B so it looks like this $B1 if you was to drag this down it would do the same as B1 but if you drag this across (left to right or right to left) it would not change it would remain $B1. Okay not lets place the $ in front of the 1 so it looks like this B$1. The same thing here if you drag this across (left to right or right to left) it would do the same as B1 but if you drag this down or up it would not change it would remain as B$1. Now the last one $B$1 it will not change regardless of the direct you drag it across the screen.

This section here I will explain a little about how to do basic math in excel.

=SUM(B4:E4) - This formula is simple adding what this does is add up all the numbers going straight down from B4 to E4 and displays the results in the cell this formula is in. Now there is more than one way to write this out you can also do it like this =SUM( B4+C4+D4+E4) and it will do the same thing. Now when you do it the 2nd way I just showed you it will for other options. When done the 2nd way it does not matter where the cells are located at it will add those cells together and give you a total for example =SUM(B4+E12+F9) you can make this as long as you want but it is best to try and break thing down specially if you have a range of number in order. Here is another example =SUM((B4:E4)+F7+R12) what this will do is add the range B4:E4 together then add F7 and R12 to them you can do this with several groups in it just enclose each with () so the program knows to add the range together. Last thing with the adding when you use the 2nd formula I showed you the word SUM does not have to be used it would simply look like this =(B4+C4+D4+E4) this will be it for adding numbers.

=(B4-F3) -This ass you know is subtracting numbers as of now I still do not know any other way of doing subtraction then what is showed. You will have to list each cell with a – separating each cell in the formula and it will subtract all the cells in order.

=(B5*B6) -This is multiplication the * tells excel to multiply you will have to do the same thing as subtraction

=(B5/B6) - This is division the / tells the system to divide the cells and you will have to do the same thing as subtraction.

Now you can combine all of these functions together and great a formula that will do all of them but you will have to write this out like you would do subtraction her is an example.

=((B5+C5)*(E4/A1)-B7) - Notice how I used () to section off the math in the formula. This will make it easier for excel to calculate your results if you leave it open you might not end up with the correct number so cell that you know that needs to do an equation first before something else you should enclose them with (). So in this formula here B5 and C5 will be add together and E4 and A1 will be divided first then those two groups will be multiplied together then B7 will be subtracted from it. If you do not section them off like this then your answer will be different Excel would do the program like this B5 + C5 then it will multiply by E4 then divide by A1 then subtract B7. So make sure you section off your mathematical equations when you are doing more than one type of math.