Hi Richard.

I have a cell tabulating the average turn around days in numbers, in a column. Cell AH8 has the code: =SUM(AR$12:AR$65536)/AH7. AH7 uses COUNTA to count the entries in column C (thanks!!). In column AR I have a formula to calculate days: =IF(OR(ISBLANK(AH12),ISBLANK(AN12)),"",(AN12-AH12)), based on date entered minus date completed. Some cells will return a negative value, due to certain time contraints. How can I get the formula in AH8 to read any negative number as a 0, or ignore the negative number completely, so it doesn't skew the average in AH8? Using Excel 2003. Thanks.

---

Answer from Richard Rost:

If you want to turn any negative results into a 0, just add another IF statement. Let's say your current result in is in B2, just say:

=IF(B2<0,0,B2)

This says, "if B2 is less than 0, then use the value 0, otherwise use whatever value is in B2."