I move data (cell for cell) from EDITED to FORMAT worksheets. But in cell C,
I only want the data if the value in E equals any of the 7 options in the
formula. Otherwise I'd like 0. I'm getting 0 whether it equals the values
or not. What am I doing wrong?

I have this formula
=IF((OR(E2="In Collect",E2="In Design",E2="In Plate",E2="In Print",E2="Ready
To Collect",E2="Ready To Design",E2="Ready to Print")),VALUE(EDITED!C2),0)


TIA,
Carole O