AVERAGE and GET RID Off ZEROs

Hello everyone ! I need help with my worksheet. I have inside 3 sheets = "DATA", "RESULTS" and "COMPOSITION" 1- for "COMPOSITION" sheet: I need to calculate "AVER." (D32) with some specific c...

Formulas and Functions

Boulakgnobot

Brass Contributor

Jul 21, 2024

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 :