formula if one cell doesn't equal another cell
 

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!

formula if one cell doesn't equal another cell
 

Calculation set to manual?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Brandy" wrote in message
...
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!

formula if one cell doesn't equal another cell
 

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

--
Gary''s Student - gsnu200799

formula if one cell doesn't equal another cell
 

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

"Brandy" wrote:

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!

formula if one cell doesn't equal another cell
 

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

"Brandy" wrote:

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!