IF function issue

[EverReady]

Below is the IF formula I am trying to use, if there is a number in column A or B greater than 0 in the I would like the result of "Good" if there is any other value in the cell then I would like the result "Unassigned". If there is a number in column A then I get the result I am looking for however if that fails and it has to look up in column B I cannot get it to produce "Unassigned". The values I am looking up with are the results of a Vlookup formula so that is why there #N/A values.

=IF(A17>0,"Good",IF(B17>0,"Good","Unassinged"))

[TABLE="width: 274"]
<tbody>[TR]
[TD]1[/TD]
[TD]#N/A[/TD]
[TD]1[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]#N/A[/TD]
[TD]2[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]#N/A[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD="align: center"]#N/A[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]#N/A[/TD]
[TD]3[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]#N/A[/TD]
[TD]5[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]#N/A[/TD]
[TD]6[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]#N/A[/TD]
[TD]7[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]#N/A[/TD]
[TD]8[/TD]
[TD]8[/TD]
[TD="align: center"]#N/A[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]#N/A[/TD]
[TD]9[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]#N/A[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD="align: center"]#N/A[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]#N/A[/TD]
[TD]11[/TD]
[TD]Good[/TD]
[/TR]
[TR]
[TD]#N/A[/TD]
[TD]12[/TD]
[TD]12[/TD]
[TD="align: center"]#N/A[/TD]
[/TR]
</tbody><colgroup><col span="3"><col></colgroup>[/TABLE]

 

[mikerickson]

What do you want to happen if there is a #N/A error?

You might try =IF(OR(IFERROR(A1,0)>0,IFERROR(B1,0)>0), "Good", "Unassigned")

 

[EverReady]

Thank you so much! This works perfectly!