if formula adjust

[vasc]

Hi my friends

How learn formula in K4 to say NO ??


thanks

[davsth]

Your title does not really reflect what you want to do, and you have not explained what you want. Do Blanks cells need excluding and how?

[vasc]

Do Blanks cells need excluding and how?

yes, blank cell exclude form result

[JeteMc]

Please edit your title so that it could help others who have a similar question. Perhaps something like "produce result based on value of two other cells".
I feel as if we need to know what the formula should yield when both of the cells in columns D and H are blank as davsth asked.
Should the corresponding cell in column K display 'NO' or should it also be blank?

[vasc]

If cell is blank result is must be NO

[JohnTopley]

=if(or(d4="",h4=""),"no","ok")

[vasc]

Perfect work, @JonnTopley

thanks