re:Nested Function

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
[email protected]
[email protected]
Eastern Time Zone

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

--
Regards,

Peo Sjoblom


"GAIL HORVATH" <[email protected]> wrote in message
news:[email protected]...
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
[email protected]
[email protected]
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
> [email protected]
> [email protected]
> Eastern Time Zone

Yes this is great!!!

--
Gail M Horvath
[email protected]
[email protected]
Eastern Time Zone
"Peo Sjoblom" <[email protected]> wrote in message
news:%[email protected]...
> =IF(AND(A3=A2,E3=E2),C3-D2,"N/A")
>
> --
> Regards,
>
> Peo Sjoblom
>
>
> "GAIL HORVATH" <[email protected]> wrote in message
> news:[email protected]...
> 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
> [email protected]
> [email protected]
> Eastern Time Zone