SOLVED

List of students with excel formula

%3CLINGO-SUB%20id%3D%22lingo-sub-2529187%22%20slang%3D%22en-US%22%3EList%20of%20students%20with%20excel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2529187%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Everyone%2C%3C%2FP%3E%3CP%3EI%20have%20students%20details%20-%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%20(4171).png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F294451i7BF6BBA3476D56C5%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%20(4171).png%22%20alt%3D%22Screenshot%20(4171).png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EConditions%20is%20-%20I%20want%20to%20name%20of%20students%20with%20the%20help%20of%20formula%20which%20-%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E1.%20Between%200-15%20Kg%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3E2.%20Above%2015%20but%20less%20than%20or%20equal%20to%2020%20Kg%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3E3.%20Above%2020%20Kg%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help..%3F%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20is%20a%20attach%20file..%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2529187%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2529352%22%20slang%3D%22en-US%22%3ERe%3A%20List%20of%20students%20with%20excel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2529352%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F811137%22%20target%3D%22_blank%22%3E%40Zan_Hanifee%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFrom%20your%20picture%20you%20do%20not%20seem%20to%20have%20XL%20365%20but%20maybe%202019.%20In%20which%20case%20in%20C2%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DIFS(B2%20%26lt%3B%2015%2C1%2C%20B2%20%26lt%3B%3D%2020%2C2%2C%20TRUE%2C3)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2529457%22%20slang%3D%22en-US%22%3ERe%3A%20List%20of%20students%20with%20excel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2529457%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20L%20z%2C%3CBR%20%2F%3ESir%2C%20It%20give%20only%20number.%20I%20want%20list%20of%20name%20according%20to%20conditions.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20am%20Using%20Microsoft%20office%202019%20Home%20and%20Student%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2529653%22%20slang%3D%22en-US%22%3ERe%3A%20List%20of%20students%20with%20excel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2529653%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F811137%22%20target%3D%22_blank%22%3E%40Zan_Hanifee%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EProblem%20misunderstood%20-%20sorry%20%26amp%3B%20Thanks%20for%20providing%20the%20Excel%20version%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Demo.png%22%20style%3D%22width%3A%20359px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F294474iB1C9EF1E338DE82F%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Demo.png%22%20alt%3D%22Demo.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20not%20a%20big%20fan%20of%20IFERROR%20so%20when%20I%20can%20avoid%20it%20I%20do.%20If%20you%20pref.%20a%20version%20with%20IFERROR%20to%20avoid%20the%20COUNTIFS%20let%20me%20know.%20See%20attached%20file%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2529671%22%20slang%3D%22en-US%22%3ERe%3A%20List%20of%20students%20with%20excel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2529671%22%20slang%3D%22en-US%22%3EThank%20you%20so%20much%20sir.%20it%20helps%20me%20a%20lot%3Asmiling_face_with_smiling_eyes%3A%3C%2FLINGO-BODY%3E
Regular Contributor

Hello Everyone,

I have students details - 

Screenshot (4171).png

 

Conditions is - I want to name of students with the help of formula which - 

1. Between 0-15 Kg

2. Above 15 but less than or equal to 20 Kg

3. Above 20 Kg

 

Please help..??

 

Here is a attach file..

 

4 Replies

Hi @Zan_Hanifee 

From your picture you do not seem to have XL 365 but maybe 2019. In which case in C2:

=IFS(B2 < 15,1, B2 <= 20,2, TRUE,3)

Hello L z,
Sir, It give only number. I want list of name according to conditions.

I am Using Microsoft office 2019 Home and Student

best response confirmed by Zan_Hanifee (Regular Contributor)
Solution

@Zan_Hanifee 

Problem misunderstood - sorry & Thanks for providing the Excel version

 

Demo.png

 

I'm not a big fan of IFERROR so when I can avoid it I do. If you pref. a version with IFERROR to avoid the COUNTIFS let me know. See attached file

Thank you so much sir. it helps me a lot