Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
formula works when referring to one cell but not to another
I'm sure there is a simple explanation but I can't come up with it. The
following is the formula I am using: =IF(OR(X2="roll not cut",X2="cut not roll"),"OK to process", " ") Basically, I am using this with a spreadsheet I receive from another user. I am just trying to automatically mark anything that says 'roll not cut' or 'cut not roll' as 'OK to process' leaving any other comments showing as a blank (to be researched by me later) This formula works fine if I use it to reference another cell that I personally type in so I know that the formula itself is ok. It must be something with the data I am receiving. I've tried copying the cells into a new column as values only but that isn't changing the result. I've tried changing the format from general to text but that isn't working. The only way that I can get this data to work is to clear the contents of the cell and copy in the retyped data from another cell (retyping alone doesn't work either) but that defeats the purpose. Any help will be greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
assign formula to another cell | Excel Worksheet Functions | |||
Deferring conditional formatting? | Excel Discussion (Misc queries) | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
How do I set a cell value based on a formula in another cell? | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions |