Sep 25 2019 03:48 AM - edited Sep 25 2019 03:49 AM
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
Sep 25 2019 01:08 PM
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")
Oct 07 2019 09:02 AM
Oct 07 2019 10:21 AM
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.