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.
Hereâs how the formula works: 1  We start with the same logical test to determine if a negative value exists using the MIN function. 2  A second IF function is then used to determine if the change from old to new is positive or negative. IF((new value â old value)>0,âPâ,âNâ)