new user question

[Michael R]

Hi
I am trying to use the following expression:
eg:

=IF(A3="","", IF(B3="","offline","online"))

where A3 is a tool number
where B3 is the date online
where C3 is the date offline

I also need to look if C3 (offline) has data in it, if so
I need it to report an error, as it can't be online &
offline at the same time.

Thanks in advance for you help...
Mike

 

[Bob Phillips]

Michael,

Try this

=IF(A3="","", IF(B3="","offline",IF(C3="","online","Error")))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Michael R]

Thanks you very much, it works great!

Mike

-----Original Message-----
Michael,

Try this

=IF(A3="","", IF(B3="","offline",IF (C3="","online","Error")))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)




.