if or formula

[Likeexcel]

Hello:
Currently I have this formula:<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
=IF(BN16="Exclude","Exclude",VLOOKUP(AG16,CC:CK,9,FALSE))<o></o>
<o> </o>
<o> </o>
I want to add that if BN16 is equal to the word “Exclude” or the number 0, then “Exclude”, otherwise vlookup AG16,CC:CK,9,FALSE<o></o>

thank you in advance!

 

[Jose_Chasez]

=IF(OR(BN16="Exclude",BN16=0),"Exclude",VLOOKUP(AG16,CC:CK,9,FALSE))<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>

 

[Jonmo1]

Try

=IF(OR(BN16={"Exclude",0}),"Exclude",VLOOKUP(AG16,CC:CK,9,FALSE))<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>

 

[Likeexcel]

Try

=IF(OR(BN16={"Exclude",0}),"Exclude",VLOOKUP(AG16,CC:CK,9,FALSE))<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>

thank you very much.

 

[Likeexcel]

Try

=IF(OR(BN16={"Exclude",0}),"Exclude",VLOOKUP(AG16,CC:CK,9,FALSE))<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>

Hi Jon:

with the formula above, could i also add this?
if BN16 minus VLOOKUP(AG16,CC:CK,9,FALSE) is greater than zero than equals the word "exclude", otherwise equals to the word "ok"

thank you again.