Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Fomula (if?)
Hi everyone! I need help with this formula, I tried an if formula, but it's
way past my ability and thought I might try the discussion group...any help would be great. WORK SHEET ONE C2 Patient D2 Surgeon E2 Group F2 empty G2 day of week H2 date of service L2 OR Suite M2 Time in room N2 Time out O2 total minutes P2 total time R2 service WORK SHEET TWO A2 GROUP B2 OR D2 DATE OF BLOCK E2 DATE CODE F2 WEEK OF MONTH G2 DAY OF WEEK H2 BLOCK START I2 BLOCK END What I need to do is determine if a surgery in worksheet one meets the criteria of the surgeons block time...is it the right group, the right date, the right day of week , is it equal to or after the start time and be for the end time? If the above is true, another thing I need but do not need to have in the same formula, is it the right room number? Any suggestions would be wonderful! Thanks so much and have a great day. Jules |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fomula needed to find the "new" time, for example if | Excel Discussion (Misc queries) | |||
Fomula | Excel Discussion (Misc queries) | |||
How can I use fill hand to copy the fomula in this case? | Excel Discussion (Misc queries) | |||
To copy fomula | Excel Worksheet Functions | |||
How to get cell value with the ID from a fomula? | Excel Discussion (Misc queries) |