No one here knows what "the spreadsheet" is. You have to explain what you
have (ie, the current formula), and what you want it changed to. Examples
are the best way of explaining what you want.

Regards,
Fred

"rhg" wrote in message
...
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",""))