AVERAGE and GET RID Off ZEROs

Boulakgnobot 

See attached.

HELP-FILTER-FILL-01.xlsx

I get lost in your nested IFs too.

So I added a table, and use XLOOKUP in columnD.

rachelThanks !

Here I want to FILL (D:D) with COLUMNS (A:A) and (C:C)

IF (A:A="Move up to a higher class" + C:C="Successful" OR "Fail")) OR (A:A="Repeats in case of failure" + C:C="Successful") = "PassB25"

IF ("Repeats in case of failure" + "Fail") OR (Exceptional repetition" + ("Successful" OR "Fail")) = "Repeat25"

IF ("Excluded in case of failure" + ("Successful" OR "Fail")) = "Exclude24"

IF ("Abandon" + "Abandon" = "Exclude24"

IF ("Move" + "Move" = "Move24"

I TRY with this below FORMULA but I still don't understand WHY it doesn't WORK ?

=IF(B3="";"";IF(OR(IF(AND(B3="3A";A3="Move up to a higher class";IF(OR(C3="Successful";C3="Fail")));IF(AND(B3="3A";A3="Repeats in case of failure";C3="Successful")));"PassB";"")

IMAGE below :

FILE link below :

https://www.cjoint.com/c/NGvtWN3UC1G

Boulakgnobot 

Updated file.

HELP-24-FILTER-DIFFERENT-CLASSES-DIFFERENT-DISCIPLINES---RACHEL---HELP-03-suite02---GET-RID-OFF-ZEROs-.xlsx

I added IF() around XLOOKUP to replace "0" with "".

rachel  Thanks !

Here, I have 3 dependent Drop-Downs (Q1), (Q2) and (M2)

The PROBLEM is that when it comes for "LEVEL {"Class_5e";"Class_6e"} (Q2) there is NO "ITV" Notes for those 2 LEVELS in 'DATA DETAILS'! Sheet so it gives me back ZEROs

SOLUTION : I want to GET RID Off z ZEROs in (I) Column

IMAGE below :

LINK below :

https://www.cjoint.com/c/NGobFKw7MnC

Boulakgnobot 

Can you try this OneDrive link:

HELP-24-FILTER-DIFFERENT-CLASSES-DIFFERENT-DISCIPLINES-22-Juin-2024---RACHEL---HELP-03-suite01---GET-RID-OFF-ZEROs.xlsx

I think something is wrong with uploading file in this site.

I tried to download some of the files I uploaded last week, didn't work either.

Thanks !

I have problem to DOWNLOAD this FILE. It gives me html file