Thread
:
Nested Function
View Single Post
#
4
GAIL HORVATH
Posts: n/a
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
Reply With Quote