Empty cell result

[vasc]

hi my friends..

i use a formula for identify cell with same number
if cell is same number formula say OK
if cell is not same number formula say NO

trouble:

empty cell formula say OK


formula is in J column and correct result in K column

how adjust formula for correct K column result?

thanks..

[José Augusto]

Hi
Try this
=IF(D3="","",IF(D3=F3,"OK","NO"))

[Pete_UK]

You can use this formula:

=IF(D3&F3="","",IF(AND(D3=F3,D3=F3),"OK","NO"))

then copy down.

Hope this helps.

Pete

[vasc]

thnanks friends...