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.
The following figure shows the formula that uses the SUM function to add the value of cell A2 and 12335. Below the formula, a ScreenTip provides guidance for using the SUM function. Notes. There is no SUBTRACT function in Excel. To subtract values by using a function, use the negative values with the SUM function.For example, the formula =SUM(30,A3,-15,-B6) adds 30 to the value in cell A3, subtracts 15, and then subtracts the value in cell B6.dd the values in a column or row by using a button. You can use AutoSum to quickly sum a range of numbers in a column or row. Click an empty cell below a column of numbers or to the right of a row of numbers, and then click AutoSum. Excel selects what it determines to be the most likely range of data.