Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date & Time | New Users to Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions | |||
Need a ISWorkday Function -- Any Ideas | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions |