Our goats are pet wethers, and I give them all our veggie peelings except raw potato. They also have fruit thats gone past it best, stale cake and bread (in moderation) and digestive biscuits as a treat (if I have to get them in for some reason).
3. Click the lower right corner of cell C1 and drag the formula down. Result: 4. To change the negative numbers to zero but leave the positive numbers unchanged, instead of =A1-B1, use =MAX(0,A1-B1) and drag the function down. Result: Explanation: the MAX function returns the maximum of two values. If the result of the formula is negative, the function returns 0.
This will tell the LOOKUP function what value to look for in our column. The next value we need to enter is the LOOKUP vector. This is the column or row that Excel must scan to find the value we are searching for. So we want to tell Excel to scan column B from row 6 to 10 to see if it can locate the value we need. Finally the result vector is used to specify the return value if Excel finds the value. The results we want Excel to return in this case is the student name so the result vector in the data is contained in column C 6 to 10.