Blank Cell - IF Statement

HI,

I am writing an if statement to determine if a condition is met, however whenever the cell is blank, it gives me a YES as opposed to a NO.

Here is the formula..

IF(J7>$J$3,"YES","NO") where J7 is the blank cell and J3 is my condition (5%) in this case. The answer should be a NO in this case as there is no value in cell J7.

Let me know if you need any more info and thanks for all the help.

jeptik

Thank you so much JieJenn. Worked like a charm.

Regards.