IF, but IF

[qwzky]

Hi! I am having a hard time figuring this out.
Maybe this is also about IFS function. My guess is that maybe it is also about COUNTIF.
Simply put, my problem looks like this:

I tried

=IFS(E2>10;"OK";IF(E2<10;"Work hard";"WORK HARD"); COUNTIF(B2:D2;"A"))

Please, help me with that. I really need that for my school as a principal.

 

[qwzky]

Thank you, guys! Your expertise is fabulous Is there any way to close this thread?

 

[Alex Blakenburg]

Glad we could help and thanks for your feedback.
Marking it as a solution as you have already done, is the closest thing the Forum has to closing the thread.
Really appreciate you caring enough to ask.