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",""))