Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 06-27-2019, 01:59 PM
soldat452002 soldat452002 is offline Multiple IF AND Statements Windows 7 64bit Multiple IF AND Statements Office 2010 64bit
Novice
Multiple IF AND Statements
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple IF AND Statements Multiple If statements, Jamal NUMAN Excel 16 11-15-2022 11:59 PM
Macro with Multiple If Statements PosieQ Excel Programming 2 04-03-2017 03:15 PM
Multiple IF AND Statements Using multiple IF statements on a mail merge ajh19742000 Mail Merge 1 11-01-2016 06:11 PM
Mailmerge certain text using multiple if statements Debs Mail Merge 4 06-19-2014 03:34 AM
Multiple If statements bremen22 Excel 2 10-15-2013 06:37 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:29 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft