#### pedie

##### Well-known Member
IF(OR(R9<>"okay",OR(R8<>"okay",R10<>"okay")),"NO","Yes")

Fornula is as above, thanks

### Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!
I didn't get any errors...

And why do you have two ORs...

Try this:

Code:
``=IF(OR(R9<>"okay",R8<>"okay",R10<>"okay"),"NO","Yes")``

AMAS

i don't see an error or a reason for one ...
only the too complicated OR is bothering me, but it is not wrong
I completely agree with AMAS's post

I understand what you guys are saying but the cell example R9,R8,R10 has no value or has ### then it gives error to my if formula too..

so can you please take a look under microscope?

OK, I put the formula into a new workbook and still no errors.

When everything is blank, the result of the formula is NO, which is what should appear.

AMAS

Try

=IF(COUNTIF(R8:R10,"Okay")<3,"NO","Yes")

Maybe you should look at correcting the errors in R8:R10 instead of trying to hide the problem.

the cell example R9,R8,R10 has no value or has ### then it gives error to my if formula too..

Hi Pedie,
jasonb75 is right in looking at the formulas returning errors first.
(What, if any, formulas do you have in R8:R10?)

just for fun you could take that CountIf formula a bit further to tell you how many of them have a problem. ie.
Code:
``=IF(COUNTIF(R8:R10,"Okay")=3,"Yes","Problem with " & 3-COUNTIF(R8:R10,"Okay")&" precedent cell(s).")``

But still, the original errors are what to take care of first if possible.

Okay great!

Thanks everyone...thanks Dan!

OK, now I understand what you meant by ###... yes a formula referencing a cell with an error will return an error.

HalfAce, I like your debugging extension to jasonb75's formula. I will have to keep this in mind if I fall into a similar problem.

AMAS

Replies
2
Views
104
Replies
7
Views
300
Replies
5
Views
231
Replies
4
Views
244
Replies
1
Views
200

1,206,718
Messages
6,074,493
Members
446,072
Latest member
OrangeYellow

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back