mardi 23 mars 2021

Excel Formula Explanation [closed]

I have been working on project and i must understand meanings of formulas below.

1:

=IF(B3="A";IF(AND(ABS(H3-AVERAGE(H3:H5))<0.1*AVERAGE(H3:H5);ABS(H4-AVERAGE(H3:H5))<0.1*AVERAGE(H3:H5);ABS(H5-AVERAGE(H3:H5))<0.1*AVERAGE(H3:H5));1;0);"")

2:

=IF(OR(AND($B2="A";$B3="A";$B4="A");AND($B2="R";$B3="A";$B4="A");AND($B2="D";$B3="A";$B4="A");AND($B2="C";$B3="A";$B4="A"));($D4-($D5+$D3)/2)*SIN(3.14/2-ATAN(($D5-$D3)/2));"")

3:

=IF(AND(V3<>"";T3=1);IF(U3*V3<=0;IF(AND(W2<>1;OR(ABS(U3)>Bilan!$C$3;ABS(V3)>Bilan!$C$3));1;0);0);0)

4:

=IF(AND(V3<>"";T3=1);IF(U3*V3<=0;IF(AND(W3<>1;X2<>1;W2<>1);IF(OR(ABS(U3)>Bilan!$C$4;ABS(V3)>Bilan!$C$4);1;0);0);0);0)

5:

=IF(AND(B2="A";B1="R");IF(C2=0;1;0);0)

I will be waiting your help.

Aucun commentaire:

Enregistrer un commentaire