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"))

1	#N/A	1	Good
2	#N/A	2	Good
#N/A	4	4	#N/A
3	#N/A	3	Good
5	#N/A	5	Good
6	#N/A	6	Good
7	#N/A	7	Good
#N/A	8	8	#N/A
9	#N/A	9	Good
#N/A	10	10	#N/A
11	#N/A	11	Good
#N/A	12	12	#N/A

<tbody>
</tbody><colgroup><col span="3"><col></colgroup>

 

[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!