Need some help with "nested if statements function" & "classifiying the group category"

Hi,

First of all, thank you for all the efforts that you’ve done for the community!

Let’s move on, I need some help with this excel file.

please find the attached file.
Book1.xlsx
I’ve asked to create fields the same idea as the one that is used in this excel file by using: “nested if statements” for “Total Absences in Days for each employee” in the file you can find it.

Also, classifiying the absences into groups same as the one in the same file.

So, can you give me the exact formula for : “nested if statements” for the Total Absences in Days for each employee in the attached excel or any idea on how to solve it?

Also, the formula for the group field for each employee after finding the Total Absences in Days for each employee ?

Or any advice would be much appreciated!

Thank you very much for all the efforts.