IFS Formula Replacement

M

mihir777

New member
Joined
May 28, 2016
Messages
24
Reaction score
0
Points
1
Excel Version(s)
2016
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
 
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.
 
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.
 
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}))
 
You must log in or register to reply here.
Back
Top