S
Sumedh Paradkar
Hello freinds,
I was working on a file which has numeric data in columns
A, B, C & D consisting of about 1000 rows. (say from row 1
to row 1000). I needed to compare whether all numbers in
the particular row are same across the columns. This means
that the number in cell A1, B1, C1 and D1 or in cell A15,
B15, C15 & D15 should be same. If they are different then
I wanted to know about them separately. So, I entered
following formula in cell E1: IF((A1+B1+C1+D1)/4-
A1=0,"OK","DIFFERENCE")and then copied it down.
This formula gave unexpected results in some cells. Even
though, the numbers are same across the columns, it gave
an answer as "DIFFERENCE" in few cells. This did not
happen in all the cells. Some cells gave correct answer
and some cells gave incorrect answer.
Please look into it.
-Sumedh Paradkar
I was working on a file which has numeric data in columns
A, B, C & D consisting of about 1000 rows. (say from row 1
to row 1000). I needed to compare whether all numbers in
the particular row are same across the columns. This means
that the number in cell A1, B1, C1 and D1 or in cell A15,
B15, C15 & D15 should be same. If they are different then
I wanted to know about them separately. So, I entered
following formula in cell E1: IF((A1+B1+C1+D1)/4-
A1=0,"OK","DIFFERENCE")and then copied it down.
This formula gave unexpected results in some cells. Even
though, the numbers are same across the columns, it gave
an answer as "DIFFERENCE" in few cells. This did not
happen in all the cells. Some cells gave correct answer
and some cells gave incorrect answer.
Please look into it.
-Sumedh Paradkar