Hi
=(A3=1)
must return TRUE for your example - otherwise you have made an error
somewhere.
--
Arvi Laanemets
(When sending e-mail, use address arvil<Attarkon.ee)
"Roze" wrote in message
...
Hi guys... I have a similiar query.... plzzzz can someone help me!
I'm constructing a spreadsheet to work out the difference in time and
date;
A1 A2 A3
07/11/04 11:00 04/11/04 10:00 3:1:00 (d:h:mm)
but now i'm trying to work out a fomula that if it goes over one day the
formula would work out true/false... i've tried doing the following but it
doesn't work;
=IF(A3=1,"Failed","Met") but it doesn't work...... doesn't seem to
register the day
Thank you
|