PokerZan Wrote:
Does taking the absolute ($) referece off of the string help?

Like this:

=IF(AND(C17<=B26+15,C17=B26-15),B17,0),IF(AND(F17<=B26+15,F17=B26-15),E17,0)

B26 is a cell that contains todays date so it should not cause a
problem. I've tried this formula and it does partly work however, for
the second set of cells it gives the false answer even when the data is
true and I don't know how to get a space to appear between the 2
values.

=IF(AND(C17<=$B$26+15,C17=$B$26-15),B17,0)&(IF(AND(F17<=$B$26+15,F17=$B$26-15),E17,0))


--
rediproof
------------------------------------------------------------------------
rediproof's Profile: http://www.excelforum.com/member.php...o&userid=23714
View this thread: http://www.excelforum.com/showthread...hreadid=374135