Forum Discussion

Maiken95's avatar
Maiken95
Copper Contributor
Sep 25, 2019

Excel issues

I'm trying to learn Excel, but I find it rather hard. There constantly seems to be some issue... 

Can you help me understand why this won't work? 

 

I started with ( , ) instead of ( ; ) but that didn't make a difference. BTW. HVISER is IFS. 

 

Thanks

Excel Desktop
Need Help

3 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Sep 25, 2019

    Maiken95 

    You incorrectly use conditions. For English locale it could be like

    =IFS([@[Custmer Age]]<25,"1",[@[Custmer Age]]<34,"2",[@[Custmer Age]]<64,"3",TRUE,"4")
    • Maiken95's avatar
      Maiken95
      Copper Contributor
      Oct 07, 2019
      What do you mean when you say conditions?

      The commas instead of ; because that makes no difference...
      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        Oct 07, 2019

        Maiken95 

        I mean logical tests. Here they are marked as red, and value returns if true - as blue.

        You second test shall be like

        ...;[@[Customer Age]]<34;...

        In your formula you compare Customer Age with nothing. And you don't need to check here if it's more than 25 - if first logical test Customer Age <25 returns FALSE, on this step you work only with ages which are more than 25. If first test returns TRUE, formula stops evaluate other tests.

Resources