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 on this entry are closed.
Get smart with the Thesis WordPress Theme from DIYthemes.