#1
|
|||
|
|||
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"))))) |
#2
|
||||
|
||||
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 |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 |
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 |