Jul 08 2021 10:04 AM
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..
Jul 08 2021 10:19 AM
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)
Jul 08 2021 10:35 AM - edited Jul 08 2021 10:39 AM
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
Jul 08 2021 11:05 AM
SolutionProblem 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
Jul 08 2021 11:09 AM
Jul 08 2021 11:05 AM
SolutionProblem 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