Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #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
  #2  
Old 06-27-2019, 11:26 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Multiple IF AND Statements Windows 7 64bit Multiple IF AND Statements Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Please post a sample sheet (no pics please) so we can work on it. Thanks


Be aware that 2 between double quotes is a text string, use 2 without quotes for numbers


What are S1,S,etc.. Cell references? If so no double quotes are needed
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply

Thread Tools
Display Modes


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 06:56 PM.


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