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.
Excel Left, Mid and Right Functions. The Excel Left function returns a specified number of characters from the left (the beginning) of a supplied text string. In the example below, the Left function returns the first two characters of the string test string: =LEFT( test string, 2 ) returns the text string te. The Excel Mid function returns a specified number of characters from the middle of a supplied text string, beginning at a specified character.