Home

Excel issues

%3CLINGO-SUB%20id%3D%22lingo-sub-874149%22%20slang%3D%22en-US%22%3EExcel%20issues%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-874149%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20learn%20Excel%2C%20but%20I%20find%20it%20rather%20hard.%20There%20constantly%20seems%20to%20be%20some%20issue...%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3ECan%20you%20help%20me%20understand%20why%20this%20won't%20work%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20started%20with%20(%20%2C%20)%20instead%20of%20(%20%3B%20)%20but%20that%20didn't%20make%20a%20difference.%20BTW.%20HVISER%20is%20IFS.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-874149%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20Desktop%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ENeed%20Help%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-875477%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20issues%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-875477%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F414874%22%20target%3D%22_blank%22%3E%40Maiken95%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20incorrectly%20use%20conditions.%20For%20English%20locale%20it%20could%20be%20like%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3E%3DIFS(%5B%40%5BCustmer%20Age%5D%5D%26lt%3B25%2C%221%22%2C%5B%40%5BCustmer%20Age%5D%5D%26lt%3B34%2C%222%22%2C%5B%40%5BCustmer%20Age%5D%5D%26lt%3B64%2C%223%22%2CTRUE%2C%224%22)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-897230%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20issues%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-897230%22%20slang%3D%22en-US%22%3EWhat%20do%20you%20mean%20when%20you%20say%20conditions%3F%3CBR%20%2F%3E%3CBR%20%2F%3EThe%20commas%20instead%20of%20%3B%20because%20that%20makes%20no%20difference...%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-897360%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20issues%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-897360%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F414874%22%20target%3D%22_blank%22%3E%40Maiken95%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20mean%20logical%20tests.%20Here%20they%20are%20marked%20as%20red%2C%20and%20value%20returns%20if%20true%20-%20as%20blue.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F135671i11132ADFEFC7B8CA%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EYou%20second%20test%20shall%20be%20like%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3E...%3B%5B%40%5BCustomer%20Age%5D%5D%26lt%3B34%3B...%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3EIn%20your%20formula%20you%20compare%20Customer%20Age%20with%20nothing.%20And%20you%20don't%20need%20to%20check%20here%20if%20it's%20more%20than%2025%20-%20if%20first%20logical%20test%20Customer%20Age%20%26lt%3B25%20returns%20FALSE%2C%20on%20this%20step%20you%20work%20only%20with%20ages%20which%20are%20more%20than%2025.%20If%20first%20test%20returns%20TRUE%2C%20formula%20stops%20evaluate%20other%20tests.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Maiken95
New 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.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies