Nesting IF or IF

[Bluesifi]

Hi

Hoping someone can help. I want advise on how to nest IF or alternative way
to get the formula to work.

I want a formula that will say if A1 - P2, and outage time is greater then 2
hours, then failed SLA, if less then 2 hours then Met SLA, or If A1 = P1, and
outage time is greater than 1 hour then failed SLA, if less then 1 hour them
Met SLA. is this posible

A1 B1
Priority Outage time
P2 00:16
P1 02:20

 

[LiAD]

Give us a list of the conditions and results u want. Example

a1-p2 = 4 and time > 2 - failed sla
a1-p2 = 4 and time < 2 - met sla
a1=p2 and time < 1 - met sla
all other possible conditions - failed sla

then u either make an if test that is nested such as

if (test;if(test a; result 1;if(test b; result 2;result 3);result 4); result
5)

or one with each condition stated

if(test 1)*(test 2);result 1; if(test 1)*(test 3); result 2; if(test
4)*(test 5);result 3; result 4);"";"")

 

[tompl]

I think this formula will do the trick:

=IF(OR(VALUE(B2)>TIMEVALUE("2:00"), VALUE(B3)>TIMEVALUE("1:00")),"Failed
SLA","Met SLA")

Tom