Excel Formula

[Huntk]

I have a problem with the query below can anyone help me with this please.

IF(O2<>"Outside SLA",O2,IF(AND(IF(F2="",G2-H2,F2-H2)>2,(F2="",G2-H2,F2-H2)<8),"Outside SLA","Within SLA"))))

What I am trying to find out is if the calculation is between 3 and seven days (as the columns we are taking the information from are in date/time.)

Hope this makes sense

 

[Aladin Akyurek]

Try to give a verbal description of what you need.

 

[Huntk]

I have now worked this problem out but thank you for replying to me, If I have any more queries I will not hesitate to use this option again.

 

[Huntk]

I have now worked this problem out but thank you for replying to me, If I have any more queries I will not hesitate to use this option again.