Thread: IF Statement not working after pasting data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dozaec Dozaec is offline
external usenet poster
  
Posts: 1
Default IF Statement not working after pasting data
Hello,
I am trying to build this formula =if(A2="Snow",1,0). It works in a
fresh, new Excel 2007 sheet but I copied some data from a 2003 version into a
2007 sheet and now my if statement won't work. I tried to format the data
using the same format in the new 2007 sheet but it still won't work. Is
there an option to use to change it?
Reply With QuoteReply With Quote