I'm not sure what you are asking , but In the formulas ribbon there is a formula auditing section. There may be some tools there that can help you.
But, if you want the forum to take a look at your formulas to figure out how to debug them, please use the xl2bb add in and post a mini sample of your dataset. If you don't know the formula, just show in the worksheets what your expectations are .. giving all the necessary inputs and calculations..