View Single Post
 
Old 06-27-2019, 01:59 PM
soldat452002 soldat452002 is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Apr 2018
Location: Los Angeles
Posts: 6
soldat452002 is on a distinguished road
Default 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")))))
Reply With Quote