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

[TABLE="width: 636"]
<colgroup><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD][TABLE="width: 648"]
<colgroup><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]name[/TD]
[TD]test1[/TD]
[TD]test2[/TD]
[TD]test3[/TD]
[TD]average[/TD]
[TD]result[/TD]
[/TR]
[TR]
[TD]mary1[/TD]
[TD]30[/TD]
[TD]100[/TD]
[TD]70[/TD]
[TD]=IFERROR(AVERAGE(B2:D2),"")[/TD]
[TD]=IF(E2>50,"pass","fail")[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Eric W]

Try:

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

 

[pgc01]

Hi

Try also

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