View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
FARAZ QURESHI FARAZ QURESHI is offline
external usenet poster
 
Posts: 553
Default HOW TO CATCH A DIFFERENT/INCONSISTENT FORMULA

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,D1:D100)

which would return True if:

D20=Sum(A1:C1)
AND
Each cell in the range D1:D1000 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.

--

Best Regards,
FARAZ A. QURESHI