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

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.

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.

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}))`

#### Posting Permissions

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