I am trying to write a formula that would essentially be an If 2 conditions are met the result wouldbe ---else----

A B C D E
Surgery Scheduled Date Room Room Start Time Room End Time Surgeon

01/02/2005 CH1 11:20 12:58 EISEN, MORRIS
01/03/2005 CH1 07:45 08:38 GLEIMER, BARRY
01/03/2005 CH1 09:54 11:46 GLEIMER, BARRY

01/03/2005 CH1 12:48 15:09 GLEIMER, BARRY
01/04/2005 CH1 07:30 09:53 KAHN, STEVEN


What I need it to do is = If A3 = A2 and E3 = E2 then C3 - D2 else "N/A"

Any ideas????
--
Gail M Horvath


Eastern Time Zone

=IF(AND(A3=A2,E3=E2),C3-D2,"N/A")

--
Regards,

Peo Sjoblom


"GAIL HORVATH" wrote in message
...
I am trying to write a formula that would essentially be an If 2 conditions
are met the result wouldbe ---else----

A B C D E
Surgery Scheduled Date Room Room Start Time Room End Time Surgeon

01/02/2005 CH1 11:20 12:58 EISEN, MORRIS
01/03/2005 CH1 07:45 08:38 GLEIMER, BARRY
01/03/2005 CH1 09:54 11:46 GLEIMER, BARRY

01/03/2005 CH1 12:48 15:09 GLEIMER, BARRY
01/04/2005 CH1 07:30 09:53 KAHN, STEVEN


What I need it to do is = If A3 = A2 and E3 = E2 then C3 - D2 else "N/A"

Any ideas????
--
Gail M Horvath


Eastern Time Zone

Hi Gail

Try
=IF(AND(A3=A2,E3=E2),C3-D2,"N/A")

HTH
Michael
--
Michael Mitchelson


"GAIL HORVATH" wrote:

I am trying to write a formula that would essentially be an If 2 conditions are met the result wouldbe ---else----

A B C D E
Surgery Scheduled Date Room Room Start Time Room End Time Surgeon

01/02/2005 CH1 11:20 12:58 EISEN, MORRIS
01/03/2005 CH1 07:45 08:38 GLEIMER, BARRY
01/03/2005 CH1 09:54 11:46 GLEIMER, BARRY

01/03/2005 CH1 12:48 15:09 GLEIMER, BARRY
01/04/2005 CH1 07:30 09:53 KAHN, STEVEN


What I need it to do is = If A3 = A2 and E3 = E2 then C3 - D2 else "N/A"

Any ideas????
--
Gail M Horvath


Eastern Time Zone

Yes this is great!!!

--
Gail M Horvath


Eastern Time Zone
"Peo Sjoblom" wrote in message
...
=IF(AND(A3=A2,E3=E2),C3-D2,"N/A")

--
Regards,

Peo Sjoblom


"GAIL HORVATH" wrote in message
...
I am trying to write a formula that would essentially be an If 2
conditions are met the result wouldbe ---else----

A B C D E
Surgery Scheduled Date Room Room Start Time Room End Time Surgeon

01/02/2005 CH1 11:20 12:58 EISEN, MORRIS
01/03/2005 CH1 07:45 08:38 GLEIMER, BARRY
01/03/2005 CH1 09:54 11:46 GLEIMER, BARRY

01/03/2005 CH1 12:48 15:09 GLEIMER, BARRY
01/04/2005 CH1 07:30 09:53 KAHN, STEVEN


What I need it to do is = If A3 = A2 and E3 = E2 then C3 - D2 else "N/A"

Any ideas????
--
Gail M Horvath


Eastern Time Zone