View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default 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!