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

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