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
Highlighted
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
Highlighted

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

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

@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
Summarzing data
Ravi_Kumar in Excel on
1 Replies
Referencing the data source for a pivot table
RobMacUK in Excel on
1 Replies
About excel filter function
broog2045 in Excel on
3 Replies
Excel file not opening
mmirfan in Excel on
1 Replies
Excel Add-In - Visio Data Visualiser - Sign in issue
MrWLJ71 in Excel on
0 Replies