I need a help for my case below.
How can I get data from that column with this specific case :
- If Days > 0 : result is greather than SLA
- If Hours = 1 and Minutes > 0 : result is greather than SLA
- If Hours > 1 : result is greather than SLA
- 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.
