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.
Change the cell formatting to make Excel recognize a negative value as a numerical or currency value to perform calculations without errors or incorrect results. 1  1. Start Microsoft Excel, and open a spreadsheet containing negative numbers in the format -100 or (100) and positive numbers in the format 100.. 2. Click the letter at the top of the column containing negative numbers. The column can also contain positive numbers. Clicking the letter highlights the full column.