Quote:
Originally Posted by Claus Busch
Hi Spencer,
Am Thu, 21 Feb 2013 10:10:12 +0000 schrieb Spencer101:
But you don't really need the value in C1. You cold just have
=IF(NOW()B1,"Available","Unavailable")
NOW() is date + time and it is always greater than a time.
Just in this moment NOW is 41326,6111829861
and CTRL+SHIFT+Point = 0,6111829861
Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
|
Hi Claus, thanks very much for your reply.
Your formula works if I remove =now() and manually enter the time.
I misrepresented what I put earlier, I have a D1 cell that contains
'=now()' and a C1 that contains
'=D1', which is probably pointless.
Is there a correct way of referencing =now() without it impairing the formula?
In regards to =now being '41326,6111829861' what do you mean?
Many Thanks,
Ryan
Edit: Just read about serial number values etc. so I understand that value.