Excel issues

Copper Contributor

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

3 Replies

@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")
What do you mean when you say conditions?

The commas instead of ; because that makes no difference...

@Maiken95 

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

image.png

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.