Got this formula:
=IF(OR(CP67>1,CZ67>1,DI67>1,DR67>1),2,"")
It should return "2" if value larger than 1 is present in one of the 4 columns, but it return value "2" in all of my 300 rows.There are formulas behind all 4 columns in hand, but (displayed) values in columns are either a blank cell or a number ranging from 1 to 3. Whole sheet is formatted as "Standard" (and table), and all values is placed to the right in the cell (not text). This should be a no-brainer, but I'm lost. Anyone that can spot what's wrong? If I do a test of this in a colmplete blank wb/sh it works just fine!
Aucun commentaire:
Enregistrer un commentaire