Can that same formula be applied to negative values? In the Workbook, the data is placed in a column, formulas calculate a value, but other colums with formulas give the # because there is a negative value not present until the next update period.