new user question

  • Thread starter Thread starter Michael R
  • Start date Start date
M

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
 
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)
 
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)




.
Click to expand...
 
Back
Top