Forum Discussion

Excel's avatar
Excel
Iron Contributor
Jul 08, 2021
Solved

List of students with excel formula

Hello Everyone,

I have students details - 

 

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

 

excel
Formulas and Functions
  • Lorenzo's avatar
    Lorenzo
    Jul 08, 2021

    Excel 

    Problem misunderstood - sorry & Thanks for providing the Excel version

     

     

    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

4 Replies

  • Excel's avatar
    Excel
    Iron Contributor
    Jul 08, 2021
    Thank you so much sir. it helps me a lot😊
  • Excel's avatar
    Excel
    Iron Contributor
    Jul 08, 2021

    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

    • Lorenzo's avatar
      Lorenzo
      Silver Contributor
      Jul 08, 2021

      Excel 

      Problem misunderstood - sorry & Thanks for providing the Excel version

       

       

      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

  • Lorenzo's avatar
    Lorenzo
    Silver Contributor
    Jul 08, 2021

    Hi Excel 

    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)

Resources