F
FARAZ QURESHI
I have a list of digits in Columns A, B & C and Column D has a formula like
=SUM(A1:C1) or AVERAGE(A1:C1) copied down.
Now is there any procedure to checkout if any formula is not consistent?
I want to develop a Custom Function like:
=Consistent(D20,D1100)
which would return True if:
D20=Sum(A1:C1)
AND
Each cell in the range D11000 consists similar formulas, e.g.
D100=Sum(A100:C100); &
D1000=Sum(A1000:C1000); etc
and False if not same, e.g.
D20=A1+B1+C1 instead of Sum(A1:C1).
Any help in formulating a code for such a function shall be highly obliged.
Thanx in advance.
=SUM(A1:C1) or AVERAGE(A1:C1) copied down.
Now is there any procedure to checkout if any formula is not consistent?
I want to develop a Custom Function like:
=Consistent(D20,D1100)
which would return True if:
D20=Sum(A1:C1)
AND
Each cell in the range D11000 consists similar formulas, e.g.
D100=Sum(A100:C100); &
D1000=Sum(A1000:C1000); etc
and False if not same, e.g.
D20=A1+B1+C1 instead of Sum(A1:C1).
Any help in formulating a code for such a function shall be highly obliged.
Thanx in advance.