Hi,

Am Thu, 21 Feb 2013 23:02:56 +0000 schrieb Ryanoo:

I misrepresented what I put earlier, I have a D1 cell that contains
-'=now()'- and a C1 that contains -'=D1'-, which is probably pointless.

try:
=IF(MOD(C1,1)B1,"Available?","Unavailable")


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2