Shorten IF OR formula

Hi all,

I want to show a value in a cell based on certain conditions. The INDEX(Dic,x,Lang) below is used to retrieve a word in the right language. Now I just realize that in addition to check if cells are not "No", there should also be a check if they are blank cells or not. I can probably do that by making below formula twice as long.. What would be the best way to make this shorter and include for each of the cells the additional check for being blank? Cells should both not be "No" and not blank before showing one value, if one of the two is true I will show another value.

=IF(OR(NOT(RawData!H16="No"),NOT(RawData!K21="No"),NOT(RawData!H36="No"),NOT(RawData!D44="No"),NOT(RawData!D45="No"),NOT(RawData!H53="No"),NOT(RawData!D61="No"),NOT(RawData!D62="No")), INDEX(Dic,35,Lang),INDEX(Dic,36,Lang))

Suggestions for the best way of doing this are very welcome.

Thanks! Although it is not a lot shorter, I think it's more clear to use <>.

My total formula would then look like this:

Formula:

Please Login or Register  to view this content.

Is there any possibility in excel to refer to a cell once to check that value is not this and not that? This just doesn't seem very efficient to me..

Thanks! That looks much better, it's also good to learn other ways of doing the same thing.