Contact | Excel Semi-Pro


Please use the form below to contact me.

Hunter October 2, 2012 at 4:57 am


Email address:


mat April 6, 2013 at 12:35 pm

Message: hi i need the assistance for the formula. I want to calculate a case acoording to three criterai. 1. hit,>7 day,case status. 2.Hit and case status. hit,out of total cases,case status. request to assit. I have used the following formula “=IF(AND(D73=1,F73=”In progress”,OR(F73=”Closed”,F73=”Inprogress”,F73=”Other site followup”)),1,0)”

Gregory April 7, 2013 at 1:26 pm

I’m sorry, but your three criteria is vague to me and the formula refers to cells that I don’t know the contents as well as “In progress” “Closed” “InProgress” and “Other site followup” is not defined. PLease explain.

Comments on this entry are closed.