| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF Statement not working after pasting data
Check the length of the data in the cells with =LEN(A2). If your cell is
going to match "snow", it will have to have a length of 4. If the cell contains space(s), it will not match "snow" Tyro "Dozaec" wrote in message ... 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pasting from another workbook was working and now is not | Excel Discussion (Misc queries) | |||
| Copy and pasting ref cells is not working | Excel Discussion (Misc queries) | |||
| IF statement for time data not working properly | Excel Worksheet Functions | |||
| IF statement not working | Excel Discussion (Misc queries) | |||
| Pasting on Filtered Data Sheets without pasting onto hidden cells | Excel Discussion (Misc queries) | |||
Linear Mode
