Please use the form below to contact me.
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. 3.case 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)”
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 are closed.