I have two columns for which I need a formula in a third to indicate if both
cells do not equal each other.
For example:

D6=402
E6=701
I need f6 to show "not ok"

I have used the formula =IF(E78=D78,"ok","not ok") but my results are
incorrect (all are saying "not ok" even if D6=402 and E6=402.

All suggestions are great appreciated.

Thank you!