TRUE/FALSE Function

  • Thread starter Thread starter Katherine
  • Start date Start date
K

Katherine

I am using the true false function in the data base -- to
identify if two columns are the same - but - does anyone
know what the formula would be to input if I wanted it to
only identify if it is two days off only and not to put
any information in the column is there is no date - it
currently puts true in when there is on information.
Thank you

Katherine
 
Katherine,

If I understand you correctly, comparing cells in columns A & B for two days
either way:

=IF(COUNT(A1:B1)<2,"",IF(ABS(A1-B1)<=2,"Close","No Cigar"))

or for column A being at least two days short of column B but not later than
column B:

=IF(COUNT(A2:B2)<2,"",IF(AND(B2-A2<=2,B2-A2>0),"Close","No Cigar"))



HTH

Sandy
 
Back
Top