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.
1 In cell B6, type the following formula: 2  and press ENTER. 3  The formula returns #NUM! (xlErrNum) because the type conversion with the CDbl function fails converting the strings x and y to type double. 4  The default return value when a function encounters a run-time error is #VALUE!. and press ENTER. 2  The formula returns The sum is 21. 3  Because the parameter for the Add3 function is declared as ParamArray, you can use a variable number of arguments for this function. 4  Note Excel limits a single worksheet function to 29 arguments.