Excel

This query is : Resolved

Querist : Anonymous

Querist : Anonymous (Querist)

27 December 2012
Simple Formula

25
30
TOTAL =SUM(B4:B5) A

But I would Like To Known That If Some One Insert A fig In Formula then How To Known

Eg:
25
30
TOTAL =SUM(B11:B12)+6 B

IF U SEE B THEN AMT 6 HAS BEEN ADDED IN THE FORMULA
HOW TO KNOWN THAT 6 HAS BEEN ADDED IN FORMULA THAT IS =SUM(B11:B12)+6

IN A NUTSHELL ANY FORMULA IS THERE TO KNOWN THAT 6 HAS BEEN ADDED IN THE FORMULA
BECAUSE THIS IS ONLY A SINGLE FORMULA BUT I AM HAVING SHEET WHICH HAS MORE THAN
120 FORMULA SO A QUICK LOOK THAT A FIG HAS BEEN ADDED IN THE FORMULA
HOW TO KNOW ??????????????????