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.
For example, enter the formula =B5-B1 and if the number in B5 is 7 and the number in B1 is 3, the cell displays the number 4. Since Excel does not have a SUBTRACT function, you can use the SUM function to subtract a range of numbers by adding negative numbers.