Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Example: The first value is always in "A3". In Table 1, use an auxiliary column, e.g. "C". Type in "B3": "= IF (A3 <> $ table2.A3; 1; 0)". If both values are equal, "0" (zero) is displayed. If they are unequal, "1" is displayed. You can now mark cell "B3". Hold the small black square on the lower right cell with the mouse and pull down. So we copied the formula down.

Example: The first value is always in "A3". In Table 1, use an auxiliary column, e.g. "C". "B". Type in "B3": "= IF (A3 <> $ table2.A3; 1; 0)". If both values are equal, "0" (zero) is displayed. If they are unequal, "1" is displayed. You can now mark cell "B3". Hold the small black square on the lower right cell with the mouse and pull down. So we copied the formula down.

Example: The first value is always in "A3". In Table 1, use an auxiliary column, e.g. "B". Type in "B3": "= IF (A3 WENN(A3 <> $ table2.A3; 1; 0)". If both values are equal, "0" (zero) is displayed. If they are unequal, "1" is displayed. displayed. WENN is in english IF. You can now mark cell "B3". Hold the small black square on the lower right cell with the mouse and pull down. So we copied the formula down.

image description

Example: The first value is always in "A3". In Table 1, use an auxiliary column, e.g. "B". Type in "B3": "= WENN(A3 <> $ table2.A3; 1; 0)". If both values are equal, "0" (zero) is displayed. If they are unequal, "1" is displayed. WENN is in english english-UI IF. You can now mark cell "B3". Hold the small black square on the lower right cell with the mouse and pull down. So we copied the formula down.

image description

Example: The first value is always in "A3". In Table 1, use an auxiliary column, e.g. "B". Type in "B3": "= WENN(A3 <> $ table2.A3; 1; 0)". If both values are equal, "0" (zero) is displayed. If they are unequal, "1" is displayed. WENN is in english-UI IF. You can now mark cell "B3". Hold the small black square on the lower right cell with the mouse and pull down. So we copied the formula down.

image description

WENN is in english-UI IF. Tabelle is table.

Example: The first value is always in "A3". In Table 1, use an auxiliary column, e.g. "B". Type in "B3": "= WENN(A3 <> $ table2.A3; 1; 0)". If both values are equal, "0" (zero) is displayed. If they are unequal, "1" is displayed. You can now mark cell "B3". Hold the small black square on the lower right cell with the mouse and pull down. So we copied the formula down.

image description

WENN is in english-UI IF. Tabelle is table.