IF/OR Forumla. Am I using the correct one?

[seorms1021]

I'm trying to write a formula that if B14 is equal to 3,4,5 or 6 then YES appears in B15, otherwise B15 is blank. I have tried IF,OR and cannot get it to work. Please help.

[benishiryo]

hi seorms1021, welcome to the forum. try:
=IF(OR(B14={3,4,5,6}),"YES","")

[seorms1021]

Hi, thank you. I tried the formula on a blank worksheet and it works. I'm having issues getting it to work on my project spreadsheet. B14 is the result of a formula. While that formula is being used, the "YES" does not appear. However, if I override the formula in B14 and manually type 3,4,5 or 6, the "YES" formula works. Any thoughts?

[seorms1021]

I figured it out. The formula result in B14 was not rounding. It would appear a 5, but would technically be 4.999, so the "YES" formula did not recognize it. Thank you for your help benishiryo!!