Thread
:
formula if one cell doesn't equal another cell
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
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!
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett