Please help me in removing #value! error in my formula, thanks

[pedie]

IF(OR(R9<>"okay",OR(R8<>"okay",R10<>"okay")),"NO","Yes")

Fornula is as above, thanks

 

[AMAS]

I didn't get any errors...

And why do you have two ORs...

Try this:

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

AMAS

 

[bobsan42]

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

 

[pedie]

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?

 

[AMAS]

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

 

[jasonb75]

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.

 

[HalfAce]

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.

=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.

 

[pedie]

Okay great!

Thanks everyone...thanks Dan!

 

[AMAS]

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