J
Jacky
The following formula has been used to perform calculations based on values
on a second sheet on the worksheet:
{=IF(COUNTA(Raw!C$12:C$41)<20,"NA",IF(ROUND((COUNT(IF(Raw!C$10="-",IF((Raw!C$12:C$41<=Raw!C$9)*(Raw!C$12:C$41<>""),Raw!C$12:C$41),IF((Raw!C$12:C$41<=Raw!C$9)*(Raw!C$12:C$41>=Raw!C$10),Raw!C$12:C$41)))/COUNTA(Raw!C$12:C$41)),2)>=0.96,"Y","N"))}
Due to some uncertainty, i've used the formular auditing function to check
the outcome from the formula, to know the step-by-step result. However, each
time the tool audit until ...COUNT(IF(Raw!C$10="-",... then the error message
will pop-up to send report to microsoft. No solution was highlighted after
the reporting.
Formula auditing tool work's perfectly fine for other formulas within the
same worksheet or that sheet itself [example:
=IF(OR(IF(G22=">2",2,G22)<0.8*IF(H22=">2",2,H22),(IF(G22=">2",2,G22)<IF(H22=">2",2,H22))*(IF(H22=">2",2,H22)<IF(I22=">2",2,I22))*(IF(G22=">2",2,G22)<0.8*IF(I22=">2",2,I22))),"-",IF(OR(IF(G22=">2",2,G22)>1.2*IF(H22=">2",2,H22),(IF(G22=">2",2,G22)>IF(H22=">2",2,H22))*(IF(H22=">2",2,H22)>IF(I22=">2",2,I22))*(IF(G22=">2",2,G22)>1.2*IF(I22=">2",2,I22))),"+","NA"))]
Please advice if a patch for the error is available.
on a second sheet on the worksheet:
{=IF(COUNTA(Raw!C$12:C$41)<20,"NA",IF(ROUND((COUNT(IF(Raw!C$10="-",IF((Raw!C$12:C$41<=Raw!C$9)*(Raw!C$12:C$41<>""),Raw!C$12:C$41),IF((Raw!C$12:C$41<=Raw!C$9)*(Raw!C$12:C$41>=Raw!C$10),Raw!C$12:C$41)))/COUNTA(Raw!C$12:C$41)),2)>=0.96,"Y","N"))}
Due to some uncertainty, i've used the formular auditing function to check
the outcome from the formula, to know the step-by-step result. However, each
time the tool audit until ...COUNT(IF(Raw!C$10="-",... then the error message
will pop-up to send report to microsoft. No solution was highlighted after
the reporting.
Formula auditing tool work's perfectly fine for other formulas within the
same worksheet or that sheet itself [example:
=IF(OR(IF(G22=">2",2,G22)<0.8*IF(H22=">2",2,H22),(IF(G22=">2",2,G22)<IF(H22=">2",2,H22))*(IF(H22=">2",2,H22)<IF(I22=">2",2,I22))*(IF(G22=">2",2,G22)<0.8*IF(I22=">2",2,I22))),"-",IF(OR(IF(G22=">2",2,G22)>1.2*IF(H22=">2",2,H22),(IF(G22=">2",2,G22)>IF(H22=">2",2,H22))*(IF(H22=">2",2,H22)>IF(I22=">2",2,I22))*(IF(G22=">2",2,G22)>1.2*IF(I22=">2",2,I22))),"+","NA"))]
Please advice if a patch for the error is available.