1. ## IFS Formula Replacement

Hello,formula for multiple conditions but as my Excel is not having IFS formula i want some formula which i can replace with.=IFs(AND(E4>=MIN("00:01"),E4=MIN("8:00"),E4=MIN("12:01"),E4=MIN("15:01"),E4=MIN("19:31"),E4  Reply With Quote

2. This is the formula i am able to use but i am not having IFS formula in Excel 2016 sstandard

=IFs(AND(E4>=MIN("00:01"),E4<=MAX("7:59")),"Out Of Time",AND(E4>=MIN("8:00"),E4<=MAX("12:00")),"SLOT 1",AND(E4>=MIN("12:01"),E4<=MAX("15:00")),"SLOT 2",AND(E4>=MIN("15:01"),E4<=MAX("19:30")),"SLOT 3",AND(E4>=MIN("19:31"),E4<=MAX("23:59")),"Out Of Time")

So need some other formula for replacement for the same.  Reply With Quote

3. What's it supposed to be doing? Why are the values being presented as text (in inverted commas)? What are the MAX and MIN functions there for (they are completely redundant)?

Just use nested IF with AND.  Reply With Quote

4. try:
Code:
`=INDEX({"Out of Time";"SLOT 1";"SLOT 2";"SLOT 3";"Out of Tim"},MATCH(E4,{0;0.3333332;0.5000001;0.6250001;0.8125001}))`  Reply With Quote

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•