Multiple IF/ISERROR Statements for Grading Formula

[eglassburn]

Hello,

I am trying to put together a grading formula that is able to account for weighted sections that are not applicable to the particular call I am monitoring. I am needing the formula to use the folloing logic:

IF D9=#DIV/0 then (Equation #1 below), IF D43=#DIV/0 then (Equation #2 below), IF D53=#DIV/0 then (Equation #3 below), IF Else (Equation #4 below)

Equations:
#1: =D12*0.11+D16*0.21+D43*0.31+D24*0.31+D53*0.06
#2: =D9*0.11+D12*0.16+(D16*0.26)+D24*0.36+D53*0.11
#3: =D9*0.06+D12*0.11+D16*0.21+D43*0.31+D24*0.31
#4: =D9*0.05+D12*0.1+D16*0.2+D43*0.3+D24*0.3+D53*0.05


I feel like I am getting close but I have not been able to get the below formula to work and hoping someone can guide me in the right direction.


Formula that I have tried using:

=IF((ISERROR(D43),(D9*0.11)+D12*0.16+(D16*0.26)+(D24*0.36)+D53*0.11,IF((ISERROR(D53),(D9*0.06)+D12*0.11+(D16*0.21)+D43*0.31+(D24*0.31),IF((ISERROR(D9),D12*0.11+(D16*0.21)+D43*0.31+(D24*0.31)+D53*0.06,(D9*0.05)+D12*0.1+(D16*0.2)+D43*0.3+(D24*0.3)+D53*0.05)))


Any assistance that can be provided is greatly appreciated. Please let me know if further clarification will be helpful.

Thanks in advance!!


Eric

 

[BenMiller]

Try

=IF(ISERROR(D9),D12*0.11+D16*0.21+D43*0.31+D24*0.31+D53*0.06,IF(ISERROR(D43),D9*0.11+D12*0.16+(D16*0.26)+D24*0.36+D53*0.11,IF(ISERROR(D53),D9*0.06+D12*0.11+D16*0.21+D43*0.31+D24*0.31,D9*0.05+D12*0.1+D16*0.2+D43*0.3+D24*0.3+D53*0.05)))

 

[eglassburn]

Thank you Ben! Works like a charm.

 

[BenMiller]

No problem Glad I could help Appreciate the feedback!