formula if one cell doesn't equal another cell

[Brandy]

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!

 

[Don Guillett]

Calculation set to manual?

 

[Gary''s Student]

=IF(ROUND(D6,0)=ROUND(E6,0),"OK","not OK")

 

[Steven]

Brandy, make sure both columns are set to the same data type.

 

[EngelseBoer]

when i have had similar issues, i have found that i have to do as Steven says
FIRST..
ie.. delete the formula - make the formats the same - then re-enter the
formula