How to using IF Function in column with text and number instead

Viewed 32

I need a help for my case below.

enter image description here

How can I get data from that column with this specific case :

  1. If Days > 0 : result is greather than SLA
  2. If Hours = 1 and Minutes > 0 : result is greather than SLA
  3. If Hours > 1 : result is greather than SLA
  4. Except point 1 to 3 : result is less than equal to SLA

It's so difficult for me to using IF functio with that specific case above. I have tried using this formula : =IF(M2="Days" > 0,"> SLA", IF(M2="Hours" = 1 & M2="Minutes" > 0, "> SLA", IF(M2="Hours" > 1, "> SLA", "<= SLA"))) But the result is not the way I want to.

Please help me guys.

0 Answers
Related