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 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 |
All times are GMT +1. The time now is 08:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com