If with multiple criteria

[casper24]

Hi,

Am hoping that you guys can help.

I am looking for a formula that shows if cell c8= Smart and cell j8 time is less than 4:00:00 them put Met SLA but if j8 is over 4:00:00 put Failed SLA and if C8= Customer raised ticket or Public raised ticket and j8 is uner 0:30:00 put Met SLA and if J8 is over 00:30:00 put failed SLA.

I have this at the moment but I cannot add in the customer and public raised part.

=IF((AND(C10>="SMART", J10<=TIME(4,0,0))), "Met SLA", "Failed SLA")

Hope this makes sense

 

[FormR]

Hi, you could try like this, which returns nothing if none of the conditions are true.

=IF(C8="Smart",IF(J8< TIME(4,0,0),"Met SLA","Failed SLA"),IF(OR(C8={"Customer Raised","Public Raised"}),IF(J8< TIME(0,30,0),"Met SLA","Failed SLA"),""))<time(4,0,0),"met sla","failed="" sla"),if(or(c8="{"Customer" raised","public="" raised"}),if(j8<time(0,30,0),"met="" sla"),""))<="" html=""></time(4,0,0),"met>

 

[casper24]

sorry, I don't understand.

 

[FormR]

sorry, I don't understand.

Hi, what don't you understand?