Need Help with interpreting existing formula arrays

[wild59flower]

Hello,
In Access 2007, is there a built in interpreter for existing formulas?

For example, I have a pre-built spreadsheet with the formulas already in certain cells. It is a long string and would like to know if there is a way to interpret what it is trying to do.

EXAMPLE:
=IF( $D$5="","",SUM($X12:$X136)/SUM($W12:$W136)*0.9)

Interpretation:
If district number (column D row 5) is blank then blank. Else equals the sum of non Title I GS State/Local Expenditures (column X) divided by the sum of non Title I GS enrollment (column W) multiplied by .9 (90%).

I realize that this interpretation is word specific to my agency but it is picking up the actual field names in the cells.

This is my first post, so I hope it is in the right group.
Thanks so much for your input.

[shg]

Your interpretation of the formula is exactly correct, assuming that's what those ranges contain.

What's your question?

[wild59flower]

Hello shg...thanks for your reply.

My question is, is there a 'quick way' to highlight the formula and click some magic button that will interpret for me instead of having to look at each cell letter/number?

Please don't laugh...just looking to speed up this process.

Thanks again...

[shg]

That's one of the reasons that people use named ranges; e.g., that formula, after creating some names, might look like this:

=IF(DistrictNo="", "", 90% * SUM(Expenditures)/SUM(Enrollment) )

Does that speak to you?

[wild59flower]

Hi shg,

Well, your formula is a little past my level. I get confused when the formula gets rearranged. Very new to excel.

I guess what i am getting at is there a built in feature in excel, or a free tool that i can download into Excel that I can use that will produce an outcome or resemble the interpreted results that I have posted above?

I need to interpret this in layman's terms and then pass on to someone else who has even less knowledge of Excel than myself.

Thanks again...

[shg]

Nothing is going to do that interpretation automatically. You can do some things (create range names and then Apply them -- essentially, tell Excel to look for an address in a formula and replace it with a name), but it's not something for a newbie to attempt on a spreadsheet that already works.

[wild59flower]

OK, doesn't hurt to ask...right.

Thanks so much for your time and information shg. I really appreciate it. I will post as Solved but that leads to another Q. Where is the advanced button so that i can close this post?

This forum is pretty cool. Take care...

[wild59flower]

never mind...found out how to mark as SOLVED. thanks again...

[shg]

Edit your first post, there's a big button and the bottom of the window that says Go Advanced.