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.
Question: In Microsoft Excel, I'm trying to use the IF function to return 0 if cell A1 is either < 150,000 or > 250,000. Otherwise, it should return A1. In this example, the formula will return 0 if cell A1 was either less than 150,000 or greater than 250,000. Otherwise, it will return the value in cell A1. Question: In Microsoft Excel, I'm trying to use the IF function to return 25 if cell A1 > 100 and cell B1 < 200. Otherwise, it should return 0.