iferror()

[lezawang]

Hi
I am using iferror() to get rid of average() function error msg when cells test1,2,3 are 0 or empty. So I did below. But I have a problem with If() (cell E2 has the average function). So if() in this case returns "pass" when test1,2,3 are 0. How to fix that? I mean can I print nothing as a result when test1,2,3 are empty or 0 values?
Thanks

name test1 test2 test3 average result mary1 30 100 70 =IFERROR(AVERAGE(B2:D2),"") =IF(E2>50,"pass","fail") <colgroup><col><col><col><col><col><col></colgroup><tbody> </tbody>

<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[Eric W]

Try:

=IF(E2="","",IF(E2>50,"Pass","Fail"))

 

[pgc01]

Hi

Try also

=IF(N(E2)>50,"pass","fail")