Thread: IF THEN
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
B B is offline
external usenet poster
 
Posts: 17
Default IF THEN

In an array, I need to identify the total number of days and dollars out of
sync if specific conditions are not met. For instance,

A report is due on X date but 3 reports later, the dollars were finally
correct. I need to calculate the number of days it took to finally get the
numbers correct and by how much the numbers were off. I have a spreadsheet
with about 300 of these entries and it took anywhere from 2 to 6 reports to
get the numbers correct.