14 Aug 09: Glenn, I couldn't tell if my reply post saying thank you for your
help was received. Your correction, of my stab at the IF statement is
working perfectly. Now that we are using the spreadsheet. I have been faced
with the question: How do we stop the formula from processing if the patient
has either had an appointment or surgery? The simple answer in my mind lies
in Columns F & G or J & K. Column F & G asks does patient have an
appointment and we just place an x in the Yes or No column. The same is true
in J & K except there we ask is the patient having surgery Yes or No. It
would seem if we put a "X" in one of those columns then we could stop the
clock so to speak. So I'm thinking, I need a STOP statement stating if
column J or K has a text entry "X" then stop processing formula in column E,
Alert Status.

=IF(OR(AND(C4="E",D4=7),AND(C4="U",D4=30)),"ALER T",IF(AND(C4="R",D4=120),"Review",""),AND(J4="X", STOP E4),OR(K4="X", STOP E4))

Any guidance is greatly appreciated.

Thank you for all your help

rhg




"Glenn" wrote:

rhg wrote:
I'm building a tracking program that monitors medical consults against time
and urgency.
Column A Column B Column C Column D Column E
Tracking # Date Urgency Time Elapsed Status
g7186072409 7/24/2009 R 14
s2234072009 7/20/2009 E 18 ALERT
a4590071809 7/18/2009 R 20
z0002071409 7/14/2009 U 24

Columns A, B & C are manual data entries
Column D =Now()-B4 (B4 is Row that contains first date)
Column E Is where my problem lies, here is my formula: =IF(OR(C4=E,&D4=7,
"ALERT", " ")+OR(C4=U,&D4=30, "ALERT", " ")+OR(C4=R,&D4=120, "Review", "
"))

I think I have too many conditions for IF to handle and I need to create a
Macro but herein lies my lack of knowledge. Any assistance would be greatly
appreciated, because we are trying to get a handle on our neurosurgery
consults. Thank you
randy


=IF(OR(AND(C4="E",D4=7),AND(C4="U",D4=30)),"ALER T",IF(AND(C4="R",D4=120),"Review",""))