Thread: How to compare and move false information to another cell
View Single Post
  #3  
Old April 4th, 2010, 04:10 AM posted to microsoft.public.excel.newusers
ozgrid.com
external usenet poster
  
Posts: 328
Default How to compare and move false information to another cell
Do you mean: =IF(OR(A2=B3,A4=B3),A4,A2) in N3?



--
Regards
Dave Hawley
www.ozgrid.com
"honjoann" wrote in message
news
I am trying to compare A2 and A4 to B3 if b3 equal A2 then move A4 to N3
if
not then move A2 to N3.
I am new to using formulas in excel