Results 1 to 4 of 4

Thread: IFS Formula Replacement

  1. #1
    Acolyte mihir777's Avatar
    Join Date
    May 2016
    Posts
    23
    Articles
    0
    Excel Version
    2016

    IFS Formula Replacement



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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. #2
    Acolyte mihir777's Avatar
    Join Date
    May 2016
    Posts
    23
    Articles
    0
    Excel Version
    2016
    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. #3
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,721
    Articles
    0
    Excel Version
    MS365 Sub (Insider) Win11
    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.

    Ali
    Enthusiastic self-taught user of MS Excel!

  4. #4
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    2,030
    Articles
    0
    Excel Version
    365
    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
  •