IF formula

[Hegemon]

Long time lurker, first time poster. I've used this forum for a long time and never had a question the search couldn't find. However, I have one now that I cannot find an answer to at all, so I finally had to register.

I want a formula that will display text if an adjacent cell is being used in a formula.

For example:

If Cell A1 has the following formula: =A2+A3+A4

I want a formula that I can put in B2, B3, B4, etc that will display some text when A2, A3, A4, etc are being used in the formula in A1.

The reason for this is that the cells in the A1 formula are added manually over time. As I add data in A5, A6, and so on, I will go back to A1 and add those cells to my tally formula. The formula I am asking for will show me which cells are part of the A1 formula. Those without text by them still need to be added to the A1 formula.

This is a simplification of the sheet I am working with. Suggestions to modify the formula in A1 will not work. I really need the formula I am asking for. If my post is confusing or if you need more info please ask. Thanks! I know you guys can help me out!