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 Excel IFNA Function. Basic Description. The Excel IFNA function tests if an initial supplied value (or expression) evaluates to the Excel #N/A error. If so, the function returns a second supplied value; Otherwise the function returns the first supplied value. Note: the IFNA function is new to Excel 2013, so is not available in earlier versions of Excel. value. The value or expression to be tested. value_if_na. The alternative value or expression, that is to be returned if the first supplied value evaluates to the #N/A error.