can you get excel to explain a formular?

[Guest]

can you get excel to show you how a formular was put together step by step in
english?

 

[Norman Jones]

Hi Seniw,

If you are seeking a verbalised explanation of custom formulae, I do not
believe that this is possible.

For standard worksheet functions, Excel's help is generally provides an
adequate description of required and available arguments.

If, you require assistance with a specific formula, post the requisite
details and a helpful someone will respond.

 

[Dave Peterson]

If you're using xl2002+, you can select the cell and then:

Tools|formula auditing|evaluate formula

And you can step through how excel evaluates each piece of the formula.

If you don't have xl2002+, you can select a portion of the formula (in the
formula bar) and hit F9 to see how it's calculated.

Hit ctrl-z to revert that portion back to the formula or hit escape to abort the
editting completely.

And if you hit enter by mistake, edit|undo right away (or ctrl-z).