Formula Tool

Hi im looking for a tool that will assist me with writting large formula's. Ideally i would like to be able to view the different values that make up the overall formula whilst working on it. This would get rid of the need to break it down into many cells inorder to track the values being used.

I hope ive explained roughly what im looking for

Regards,

ceemo

Ive had a few views does anyone know of any such tool?

no its just something i imagine would be good and if it does not exist i hope someone will create and offer me a free version for my idea.

It would be a handy tool do you not agree?

I don't know if this is exactly what you're looking for, but when I have a large and/or complex formula to write, I will write a user-defined function in VBA, especially if it's a function I'll use fairly frequently. While writing and debugging the code, I can monitor various values and operations through the watch window. Then, after I get the function all coded and debugged, I can enter that function into the cell(s) instead of having a large function enterred into a worksheet.
Just a thought, don't know if that would satisfy you or not.

thnx for the tip