Multiple IF AND Statements
Hello
My formula with multiple IF/AND Statements is not working.
I have a formula to bring back the days the record has been opened, and
once that has been calculated my formula is to provide me if a record is out of SLA or within SLA. Not sure what im doing wrong.
--Calculate days opened
=NETWORKDAYS([@[Date Created]],NOW())
--SLA Days
S1 1 day -24 hrs
S2 5 days
S3 14 days
S4 30 days
--formula to calculate SLAs
=IF(AND([@[Dates Opened]]>"2",[@[Severity Level]]="S1"),"Within SLA",
IF(AND([@[Dates Opened]]>"6",[@[Severity Level]]="S2"),"Within SLA",
IF(AND([@[Dates Opened]]>"16",[@[Severity Level]]="S3"),"Within SLA",
IF(AND([@[Dates Opened]]>"30",[@[Severity Level]]="S4"),"Within SLA",
IF([@[Severity Level]]="Not Applicable","Not Applicable","Out of SLA")))))
|